Column Name = column does not exist - Mailing list pgsql-novice

From brian stapel
Subject Column Name = column does not exist
Date
Msg-id BAY107-W4154BB2CCD4D0358C801BA1BC0@phx.gbl
Whole thread Raw
Responses Re: Column Name = column does not exist  (Sean Davis <sdavis2@mail.nih.gov>)
Re: Column Name = column does not exist  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-novice
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?
 
Thanks again.


Get the Live.com Holiday Page for recipes, gift-giving ideas, and more. Check it out!

pgsql-novice by date:

Previous
From: Robert Rak
Date:
Subject: Re: select from different database
Next
From: Sean Davis
Date:
Subject: Re: Column Name = column does not exist