Postgres

The sq Postgres driver implements connectivity for the Postgres database. The driver implements all optional driver features.

Add source #

Use sq add to add a source. The location argument should start with postgres://. For example:

sq add 'postgres://sakila:p_ssW0rd@localhost/sakila'

Non-default schema #

By default, the Postgres driver connects to the default public schema. To use an alternate schema, add the search_path param to the location string when adding the Postgres source.

For example, to use the customer schema:

sq add 'postgres://sakila:p_ssW0rd@localhost/sakila?search_path=customer'

Note that the location string should be quoted due to the ? character.