postgres.md

title	description	draft	images	weight	toc	url
Postgres	Postgres driver	false		4020	false	/docs/drivers/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.