Database name with semicolon - Mailing list pgsql-general

Hi,

We have a windows application which communicate to Postgres database via PostgreSQL ODBC drivers for windows.

One of our customers has a database with semicolon in its name (e.g.: “db; name”) and our application is failing to establish connection to that database saying like it could not find the database.

We tried all known possibilities by enclosing the DB name under quotes, curly brackets etc. but none solved the problem.

I wonder whether there is any possible way to achieve connection to such database. If not, probably it’s better not to support semicolons within the database name.

Not sure whether I need to submit this query as a bug or not. Any help is much appreciated.

Thanks and Regards,

Joby John