Dave Page wrote:
> It has to otherwise PostgreSQL will fold the identifier to lowercase.
I prefer mixed-case multi-word identifiers rather than identifiers with
words separated by underscors but I think I will use lowercase
everywhere from now on :/
>>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.
you guessed right. I checked up on it at
Doesn't seem like there are many words left in the english language that
aren't reserved ;) I didn't realise there were so many [non-]reserved
words. Postgres reserves GLOBAL as a "non-reserved" word as opposed to a
"reserved" word (just read the docs from the above link).
A print out of this list now stays by my side...
Terence Kearns ~ ph: +61 2 6201 5516
IT Database/Applications Developer
Enterprise Information Systems
Client Services Division
University of Canberra
In response to
pgadmin-support by date
|Next:||From: Andreas Pflug||Date: 2003-07-17 08:56:35|
|Subject: Re: double quoted object names|
|Previous:||From: Erwien Samantha Y||Date: 2003-07-17 08:20:43|
|Subject: Re: pgAdmin III Screenshots|