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