public inbox for [email protected]
help / color / mirror / Atom feedFrom: Alan B <[email protected]>
To: [email protected]
Subject: Add clarification example to EXEC SQL CONNECT with password
Date: Thu, 20 Sep 2012 18:17:15 +0200
Message-ID: <CAGbN=G6P1dy4Q03oKdQig_oUWj82W_x67MRMwX2J+9DrFc=cxw@mail.gmail.com> (raw)
Hi list,
Hope this is the right place to suggest that change in the docs, otherwise
is there a ticket management system for this stuff somewhere?
Paying attention to the documentation at
http://www.postgresql.org/docs/8.4/static/ecpg-connect.html and subsequent
versions of the page (I am using 8.4), there is the option to specify
"user-name" in various ways. However this may be confused as a single
parameter to the connect string while it is a combination of 1 or 2
parameters that cannot go into a single string.
To avoid confusion I suggest providing a complete example in "Here are some
examples of CONNECT statements:" as follows:
EXEC SQL CONNECT TO [email protected];
EXEC SQL CONNECT TO unix:postgresql://sql.mydomain.com/mydb AS
myconnection USER john;
EXEC SQL BEGIN DECLARE SECTION;
const char *target = "[email protected]";
const char *user = "john";
const char *passwd = "secret";
EXEC SQL END DECLARE SECTION;
...
EXEC SQL CONNECT TO :target USER :user USING :passwd;
or
EXEC SQL CONNECT TO :target USER :user/:passwd;
To make the distinction of parameters and string variables evident.
Alan
view thread (11+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: Add clarification example to EXEC SQL CONNECT with password
In-Reply-To: <CAGbN=G6P1dy4Q03oKdQig_oUWj82W_x67MRMwX2J+9DrFc=cxw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox