Re: psql connection option: statement_timeout
От | Daniel Verite |
---|---|
Тема | Re: psql connection option: statement_timeout |
Дата | |
Msg-id | ce932bde-e48a-48f5-b19b-cad2d854af94@mm обсуждение исходный текст |
Ответ на | Re: psql connection option: statement_timeout (Craig Boyd <craig@mysoftforge.com>) |
Ответы |
Re: psql connection option: statement_timeout
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: