Re: Database name with semicolon

2018-06-29 Thread Gavin Flower
On 29/06/18 04:22, joby.john@nccgroup.trust wrote: 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

Re: Database name with semicolon

2018-06-29 Thread 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 with

Re: Database name with semicolon

2018-06-28 Thread Pavel Stehule
2018-06-28 12:10 GMT+02:00 joby.john@nccgroup.trust < 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 t

Re: Database name with semicolon

2018-06-28 Thread Thiemo Kellner
Zitat von "joby.john@nccgroup.trust" : Not sure what else I can try or whether the ODBC driver supports database name with a semicolon at all. Not knowing much about ODBC, how about single quotes? And if you pass the entire URL, would it be possible to pass instead values to Kind of functio

Re: Database name with semicolon

2018-06-28 Thread 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;

RE: EXTERNAL: Re: Database name with semicolon

2018-06-28 Thread Joby John
From: Pavel Stehule [mailto:pavel.steh...@gmail.com] Sent: 27 June 2018 15:26 To: Joby John Cc: pgsql-gene...@postgresql.org Subject: EXTERNAL: Re: Database name with semicolon Hi 2018-06-27 15:22 GMT+02:00 Joby John mailto:Joby.John@nccgroup.trust>>: Hi, We have a windows application

Re: Database name with semicolon

2018-06-27 Thread Adrian Klaver
On 06/27/2018 06:22 AM, Joby John wrote: 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

Re: Database name with semicolon

2018-06-27 Thread Vick Khera
On Wed, Jun 27, 2018 at 10:25 AM, Pavel Stehule wrote: > Hi > > > modern Postgresql has not any problems with special chars > > I think the issue is that he cannot create a proper connection string to pass to the ODBC driver, since semi-colon is used as a delimiter for the fields.

Re: EXTERNAL: Re: Database name with semicolon

2018-06-27 Thread Pavel Stehule
bname = '"; sss"' > > Regards, > > Joby John > > > > *From:* Pavel Stehule [mailto:pavel.steh...@gmail.com] > *Sent:* 27 June 2018 15:26 > *To:* Joby John > *Cc:* pgsql-gene...@postgresql.org > *Subject:* EXTERNAL: Re: Database name wit

Re: Database name with semicolon

2018-06-27 Thread Pavel Stehule
Hi 2018-06-27 15:22 GMT+02:00 Joby John : > 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 establi

Database name with semicolon

2018-06-27 Thread Joby John
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 fi