Re: double quoted object names

> -----Original Message-----
> From: Terence Kearns [mailto:terencek@isd.canberra.edu.au]
> Sent: 17 July 2003 07:34
> To: Andreas Pflug
> Cc: Dave Page; pgadmin-support@postgresql.org
> Subject: double quoted object names
>
>
> Andreas Pflug wrote:
> > and fooCol is not the same as "fooCol"
>
> What is the deal with this anyway? Everytime I specify an object name
> with mixed case it decides to throw double quotes around it.

It has to otherwise PostgreSQL will fold the identifier to lowercase.

> Also, I created a schema called global (no mixed case) and now
> pgAdminIII refers to all objects in this schema as "global".objectname

Global is probably a reserved word, so must be quoted if used.

Regards, Dave.