Re: double quotes in unicode dbs

>        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.

With kind regards / mit freundlichem Gruß
    Holger Klawitter
--
Holger Klawitter                          http://www.klawitter.de
lists@klawitter.de