> -----Original Message-----
> From: Terence Kearns [mailto:[EMAIL PROTECTED]
> Sent: 17 July 2003 07:34
> To: Andreas Pflug
> Cc: Dave Page; [EMAIL PROTECTED]
> 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.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
