i changed my connection string as follows keeping newDB in double quotes
EXEC SQL CONNECT TO tcp:postgresql://192.168.1.1:5432/"newDB"
Unfortunately these doulbe quotes lead to syntax error.
Can you tell me what is the right syntax for the same.
Thanks
On 10/13/06, Tom Lane <tgl@sss.pgh.pa.us> wrote: "J S B" <jsbali@gmail.com> writes:
> well, newDB is the name of the database and that what I'm tryin to connect.
> I'm tryin to keep it the same case in ECPG code as it is in the Database.
> Do u mean to say that combination of upper and lower case is not allowed?
No, I mean to say that names will get downcased in some situations if
not double-quoted. I wonder whether your database is *really* named
"newDB" and not "newdb" ... if it is, you probably need double quotes in
your ECPG call, and if it isn't, you probably need to spell it as newdb
not newDB in ECPG.
regards, tom lane