Skip site navigation (1) Skip section navigation (2)

Re: Column Name = column does not exist

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: brian stapel <brians_224(at)hotmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Column Name = column does not exist
Date: 2007-01-09 17:09:00
Message-ID: 20070109170900.GA19523@wolff.to (view raw or flat)
Thread:
Lists: pgsql-novice
On Mon, Jan 08, 2007 at 16:38:57 -0600,
  brian stapel <brians_224(at)hotmail(dot)com> wrote:
> Thanks for your time.
>  
> I'm in the process of trying to incorporate three Human Resource systems into one.  Each of the three systems had a different author and no standards were followed - consequently the table design leaves a bit to be desired.  One of the most critical tables has a field named:Last_Name (case specific).  When I execute 'Select Last_Name from employee' the statement fails with the following message: column "last_name" does not exist.  If I wrap the field name in quotes "Last_Name" for example, the query works as expected.
>  
> Is this typical behavior?

Yes. In postgres, unquoted column and table names are converted to lower case.

In general, the advice is to either never quote names or always quote them.

In response to

pgsql-novice by date

Next:From: Mathieu PeltierDate: 2007-01-09 19:36:39
Subject: Are postgresql 8.2.1 RPMs signed?
Previous:From: Sean DavisDate: 2007-01-09 13:37:08
Subject: Re: Keeping a Backup database in sync with the primary

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group