Re: BUG #2764: Capital letter in tables or columns not

Jaime Casanova wrote:
> On 11/17/06, Ron Teitelbaum <ron@usmedrec.com> wrote:
> >
> > The following bug has been logged online:
> >
> > Bug reference:      2764
> > Logged by:          Ron Teitelbaum
> > Email address:      ron@usmedrec.com
> > PostgreSQL version: 1.4.1
> > Operating system:   Windows
> > Description:        Capital letter in tables or columns not supported
> > Details:
> >
> > I ran into a very weird problem that tured out to be a capital letter in the
> > table name or column name.  When trying to query a table with a capital
> > letter in the name I get error relation not defined.
> >
> > I can get it to work with something like:
> >    select * from "zipCodes"
> >
> > It appears to be completely case insensitive if the table is all lowercase.
> >
> >
>
> that's not a bug... if you create a table or column with capital
> letters postgres transform it to lowercase...
>
> if you don't want that you need to double quotes...
>
> create table "Foo" (Col1 int);
> select * from "Foo";

I added a mention of "capitalization" in the FAQ item on this:

    <H3 id="item4.21">4.21) Why are my table and column names not
    recognized in my query?  Why is capitalization not preserved?</H3>

--
  Bruce Momjian   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +