Re: double quotes in unicode dbs - Mailing list pgsql-general

Holger Klawitter <lists@klawitter.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@myxomop.com
   http://garcia.myxomop.com/NiddWiki   Deadheads, unite!
           Kill 'em all, and let God sort 'em out