Search Postgresql Archives

Re: EXTERNAL: Re: Database name with semicolon

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi

2018-06-27 16:39 GMT+02:00 Joby John <Joby.John@nccgroup.trust>:

Hi Pavel,

 

Thanks for coming back to me.



 

The version of the Postgres server where I am trying is: 9.5.3


9.5 is modern Postgres. There should not be problems with names.

 

Yes, I tried putting the database name in double quotes with no luck.

Please note we are using PostgreSQL Unicode ODBC driver (version 10.2) to communicate with the server.


looks like ODBC issue - semicolon has some semantic there


but probably you read these pages

Maybe some combination of quotes is necessary


you can try

dbname = '"ssss; sss"'



 

Regards,

Joby John

 

From: Pavel Stehule [mailto:pavel.stehule@gmail.com]
Sent: 27 June 2018 15:26
To: Joby John <Joby.John@nccgroup.trust>
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: EXTERNAL: Re: Database name with semicolon

 

Hi

 

2018-06-27 15:22 GMT+02:00 Joby John <Joby.John@nccgroup.trust>:

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.

 

modern Postgresql has not any problems with special chars

 

postgres=# create database "bad name ;;;;";
CREATE DATABASE
postgres=# \q
[pavel@nemesis ~]$ psql 'bad name ;;;;'
psql (11beta1)
Type "help" for help.

bad name ;;;;=#

 

What is version of Postgres?

 

Did you try double quotes?

 

Regards

 

Pavel

 

 

 

Thanks and Regards,

Joby John


Joby John
Software Developer
NCC Group
Kings Court, Kingston Road, Leatherhead, KT22 7SL

Telephone: +44 1372 383 800
Mobile:
Website: www.nccgroup.trust
Twitter: @NCCGroupplc


This email is sent for and on behalf of NCC Group. NCC Group is the trading name of NCC Services Limited (Registered in England CRN: 2802141). The ultimate holding company is NCC Group plc (Registered in England CRN: 4627044). This email may be confidential and/or legally privileged.

 


Joby John
Software Developer
NCC Group
Kings Court, Kingston Road, Leatherhead, KT22 7SL

Telephone: +44 1372 383 800
Mobile:
Website: www.nccgroup.trust
Twitter: @NCCGroupplc

This email is sent for and on behalf of NCC Group. NCC Group is the trading name of NCC Services Limited (Registered in England CRN: 2802141). The ultimate holding company is NCC Group plc (Registered in England CRN: 4627044). This email may be confidential and/or legally privileged.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux