Re: double quotes in unicode dbs

Holger Klawitter <lists(at)klawitter(dot)de> writes:

>> SELECT * FROM TEST1;
>>
>> works, but
>>
>> SELECT * FROM "TEST1";
>
> It might be a normal case problem.
>
> Doublequotes make Postgres preserve the case of table names otherwise every is
> being converted to lower case. Probably your table is named in lowercase
> (either by creating it using "test1" or TEST1 without the double quotes).
> You can see the interal name with the "\d" command.

Thank you very much. It helped me to solve the problem.

--
Peter Novodvorsky nidd(at)myxomop(dot)com
http://garcia.myxomop.com/NiddWiki Deadheads, unite!
Kill 'em all, and let God sort 'em out