Postgres is configured with a single datasource property. It should follow the following format:
postgres://username:password@host:port/database.
Example:
# DATABASE_URL defined as environment variable as
# postgres://username:password@host:port/database
datasource: ${env.DATABASE_URL}
query: select * from users;
# DATABASE_URL defined as environment variable as
# postgres://username:password@host:port/database
datasource: ${env.DATABASE_URL}
query: select * from users;
---DATABASE_URL defined as environment variable as
---postgres://username:password@host:port/database
--{{ config "datasource" "postgresql://${env.PG_USER}:${env.PG_PASS}@${env.PG_HOST}:${env.PG_PORT:5432}/${env.PG_DB}?sslmode=no-verify&schema=newjitsu" }}
select * from users;
