Search Postgresql Archives

Re: Question about password character in ECPG's connection string

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello Yusuke,

Il giorno mar, 27/08/2019 alle 07.29 +0000, Egashira, Yusuke ha
scritto:
[...]
> I referred the below documents.
> - CONNECT of ecpg: 
> https://www.postgresql.org/docs/9.5/ecpg-sql-connect.html
> - Connection string of libpq: 
> https://www.postgresql.org/docs/9.5/libpq-connect.html#LIBPQ-CONNSTRING
[...]

It seems to me that ECPG documentation does not allow specifying
username and/or password in the connection string. The correct syntax
should be:

EXEC SQL CONNECT TO "unix:postgresql://localhost/connectdb" USER
"myuser" IDENTIFIED BY "pass&word"

Bye,
Giuseppe






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux