Hi Adrian
I had missed that bit. That makes sense now.
Cheers
Phil Jackson
On 6/30/2010 5:04 PM, Adrian Klaver wrote:
On Thursday 01 July 2010 11:11:29 am Phil Jackson wrote:
Hi Adrian
The link says that;
"Identifier and key word names are case insensitive."
But I have renamed the source table in lowercase and this gets me one
step further.
I'll carry on and see what happens next.
Cheers
Phil Jackson
You need to go to bottom of that section where you would find :)
"Quoting an identifier also makes it case-sensitive, whereas unquoted names are
always folded to lower case. For example, the identifiers FOO, foo, and "foo"
are considered the same by PostgreSQL, but "Foo" and "FOO" are different from
these three and each other. (The folding of unquoted names to lower case in
PostgreSQL is incompatible with the SQL standard, which says that unquoted
names should be folded to upper case. Thus, foo should be equivalent to "FOO"
not "foo" according to the standard. If you want to write portable applications
you are advised to always quote a particular name or never quote it.) "
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
