postgres.git / summary / log / commit / refs

commit    dc33b0961eb9628290c29f465ef416c8991a3f0c
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Fri Jan 25 16:18:44 2013 +0000
First released in: 9.3.0, 9.2.3

    docs:  In ecpg, clarify how username/password colon parameters are used
    
    Backpatch to 9.2.
    
    Patch from Alan B


doc/src/sgml/ecpg.sgml | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/ecpg.sgml b/doc/src/sgml/ecpg.sgml index 63aaf89b87f..bf01857a4c2 100644 --- a/doc/src/sgml/ecpg.sgml +++ b/doc/src/sgml/ecpg.sgml @@ -194,9 +194,12 @@ EXEC SQL CONNECT TO unix:postgresql://sql.mydomain.com/mydb AS myconnection USER EXEC SQL BEGIN DECLARE SECTION; const char *target = "mydb@sql.mydomain.com"; const char *user = "john"; +const char *passwd = "secret"; EXEC SQL END DECLARE SECTION; ... -EXEC SQL CONNECT TO :target USER :user; +EXEC SQL CONNECT TO :target USER :user USING :passwd; + +EXEC SQL CONNECT TO :target USER :user/:passwd; </programlisting> The last form makes use of the variant referred to above as character variable reference. You will see in later sections how C [parent: a33c0045a86d]