Re: Problem with table name in capitals.

--- Kurt Roeckx <Q(at)ping(dot)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