Question about password character in ECPG's connection string

Hi, I have question about connection string of ECPG's CONNECT statement. I'm using postgresql 9.5.17 with ECPG application. When I trying to connect to the database, I found that some characters as password in ECPG's connection_option cannot be accepted. Is the specification of ECPG's connection

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

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 "

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

> > Perhaps it helps to URL-encode the & in the password as %26? > > The OP already did without success. Yes, I already get failed with URL-encode the &. > Could it be needed to escape the & with the backslash or single ticks? Thanks. I tested with "pass\&word" and "'pass&word'". However, them

Question about array_to_string()'s behavior and the behavior might be changed in the future or not

Hi, I have a question about array_to_string(). I think array_to_string() concatenates always array elements from the "beginning" of the array elements and this rule will not be changed on the future minor releases. Is my understanding correct? For example, I understand that array_to_string(

RE: Question about array_to_string()'s behavior and the behavior might be changed in the future or not

Hi, Andrew Thank you for immediate replying. I'm relieved. Regards. -- Yusuke, Egashira -Original Message- From: Andrew Gierth [mailto:and...@tao11.riddles.org.uk] Sent: Thursday, January 17, 2019 3:56 PM To: Egashira, Yusuke/江頭 勇佑 Cc: 'pgsql-gene...@postgresql.org