Re: Backup DB not getting connected

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "J S B" <jsbali(at)gmail(dot)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
>