Re: psql connection option: statement_timeout

Craig Boyd wrote:

> So to put it another way: is there a list that shows what options are
> available during the connection event or as part of the connection string?

Yes, but it belongs to the chapter on libpq. The psql docpage merely points
to it:

<quote>
-d dbname
--dbname=dbname

Specifies the name of the database to connect to. This is
equivalent to specifying dbname as the first non-option argument
on the command line.

If this parameter contains an = sign or starts with a valid URI
prefix (postgresql:// or postgres://), it is treated as a
conninfo string. See Section 31.1.1 for more information.
</quote>

In the HTML-formatted doc, this "Section 31.1.1" links to:
https://www.postgresql.org/docs/9.3/static/libpq-connect.html#LIBPQ-CONNSTRING
which has the list you want.

Besides connection options such as "connect_timout", it happens
that server config options, such as "statement_timeout", can also
be incorporated into a connection string, through the
"options" keyword and -c switch (possibly used multiple times)

For example:

$ psql -d "dbname=test connect_timeout=10 options='-c statement_timeout=1000
-c geqo=off'"

psql (9.3.13)
Type "help" for help.

test=> show statement_timeout ;
statement_timeout
-------------------
1s
(1 row)

Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite