Re: Database name with semicolon

[joby.john@nccgroup.trust]

> See if something like below works:
> {db; name}



Hi,

Thanks for the responses.

I tried putting curly brackets around the value of database like you
mentioned.
{db; name}
But the server was treating the brackets as part of the database name and so
did not work.
I tried double quotes like 
"db; name" which also didn't work.

Not sure what else I can try or whether the ODBC driver supports database
name with a semicolon at all.
I know that in the case of password we can put the string enclosed within
curly brackets to escape special characters but not appears to be working
for the database.

Regards,
Joby 



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: Database name with semicolon

[joby.john@nccgroup.trust]

Pavel Stehule wrote
> 2018-06-28 12:10 GMT+02:00 please, can you try'"db; name"' .. double
> quotes nested in apostrophes

I tried this with no luck. Also tried the other way, apostrophe nested in
double quotes with same results.Looks like an issue in ODBC driver as it's
not handling semicolon within database name. Probably needs to go back to
the client asking to rename the database.



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html