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

From Thomas Beutin
Subject Re: double quotes in unicode dbs
Date
Msg-id 20020808150808.E8821@laokoon.bug.net
Whole thread Raw
In response to double quotes in unicode dbs  (Peter Novodvorsky <nidd@altlinux.com>)
List pgsql-general
Hi Peter,

On Thu, Aug 08, 2002 at 04:48:02PM +0400, Peter Novodvorsky wrote:
>    I'm writing native driver for OpenOffice.Org for PostgreSQL. I used
> to use 8-bit charset db to test a driver (koi8-r, actually), and when I
> tried UNICODE db I've found the following problem: queries with double
> quotes don't work. For example,
>
>        SELECT * FROM TEST1;
>
> works, but
>
>        SELECT * FROM "TEST1";
>
> doesn't. I'd gladly remove all quoting of table names, but it is done
> by sdbc layer of OpenOffice.Org, and I don't want to hack it.
>
If You are quoting the table names they are treated case sensitive.
Is there an table TEST1 in Your database?

Greetings,
-tb
--
Thomas Beutin                             tb@laokoon.IN-Berlin.DE
Beam me up, Scotty. There is no intelligent live down in Redmond.

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Create index ... On ... (lower(field1), lower(field2)) doesn't work?
Next
From: "Joel Joseph"
Date:
Subject: working with arrays question