Re: Problem with table name in capitals. - Mailing list pgsql-odbc

From Jeff Eckermann
Subject Re: Problem with table name in capitals.
Date
Msg-id 20021214041701.14506.qmail@web20810.mail.yahoo.com
Whole thread Raw
In response to Problem with table name in capitals.  (Kurt Roeckx <Q@ping.be>)
Responses Re: Problem with table name in capitals.
List pgsql-odbc
--- Kurt Roeckx <Q@ping.be> wrote:
> When I'm using a table with capitals from excel or
> something,
> using microsoft query, I get an error that the
> relation
> "public"."table" doesn't exist.
>
> I noticed that I got simular errors when I didn't
> put quotes
> around the name of the table.  I assume it's the
> same problem
> here?
>
> When I rename the table/column to lower case it
> works.
>
> Is this a problem in the ODBC driver, or in
> microsoft query?

Neither one.  Table/column names in PostgreSQL are
case insensitive, as the SQL standard requires.  In
PostgreSQL this is achieved by forcing all names to
lower case before evaluation.  Quoted names are not
changed, as you found.  You will need to rename your
tables/columns to lower case names, or always quote
them in queries.

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

pgsql-odbc by date:

Previous
From: Kurt Roeckx
Date:
Subject: Problem with table name in capitals.
Next
From: Kurt Roeckx
Date:
Subject: Re: Problem with table name in capitals.