Postgres is configured with a single datasource property. It should follow the following format:
postgres://username:password@host:port/database.Example:
model.yaml
model.sql
# DATABASE_URL defined as environment variable as# postgres://username:password@host:port/databasedatasource: ${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;