diff options
| author | Bruce Momjian <bruce@momjian.us> | 2013-01-25 11:18:44 -0500 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2013-01-25 11:18:44 -0500 |
| commit | dc33b0961eb9628290c29f465ef416c8991a3f0c (patch) | |
| tree | 51cf3be00915aff5cf558d37e38e1c8a8db92258 | |
| parent | a33c0045a86d128d175e94f472e575b7daaecb91 (diff) | |
| download | postgresql-dc33b0961eb9628290c29f465ef416c8991a3f0c.tar.gz postgresql-dc33b0961eb9628290c29f465ef416c8991a3f0c.zip | |
docs: In ecpg, clarify how username/password colon parameters are used
Backpatch to 9.2.
Patch from Alan B
| -rw-r--r-- | doc/src/sgml/ecpg.sgml | 5 |
1 files changed, 4 insertions, 1 deletions
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 |