Horton

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

Egashira, Yusuke <egashira.yusuke@jp.fujitsu.com>

View thread View on postgr.es
From: "Egashira, Yusuke" <egashira.yusuke@jp.fujitsu.com>
To: 'Giuseppe Sacco' <giuseppe@eppesuigoccas.homedns.org>, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2019-08-28T01:18:48Z
Lists: pgsql-general 
Hi, Giuseppe,

Thanks to response to my question!

> 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"

Yes, I could connect to database with "USER" and "IDENTIFIED BY" phrase in CONNECT statement.
However, I could also connect to database with password in connection string when my password does not contains '&' character.

1. In database, 
   > CREATE ROLE myuser LOGIN PASSWORD 'password';
2. In ECPG application,
   EXEC SQL CONNECT "tcp:postgresql://localhost?user=myuser&password=password";
     -> The connection was succeeded.

This behavior confuse me. 

If user and password cannot write in connection string, what are parameters allowed in "connection_option" ?
I hope I can get this information from the ECPG documentation.

Regards.

--
Yusuke, Egashira.

Commits

  1. Doc: describe the "options" allowed in an ECPG connection target string.

  2. Cosmetic improvements for options-handling code in ECPGconnect().