Here's the situation...

I had a few tables left over from a small 6.5.2 database.  By '\d'ing I can
see a table named Employee in the list.  If I try to select from the table I
get the following...

\d returns...

 | damond           | Employee                         | table    |

select * from employee returns....

ERROR:  employee: Table does not exist.

---
Damond Walker



Sun, 7 Nov 1999 13:55:26 -0800
"Damond Walker" <dwalker@black-oak.com>
Re: [HACKERS] psql and 6.5.3
> I had a few tables left over from a small 6.5.2 database.
>  | damond           | Employee                         | table    |
> select * from employee returns....
> ERROR:  employee: Table does not exist.

Gotta use

  select * from "Employee";

and it has always been this way (since we implemented mixed-case
capabilities anyway...).

                  - Thomas

-- 
Thomas Lockhart				lockhart@alumni.caltech.edu
South Pasadena, California

Sun, 07 Nov 1999 23:37:45 +0000
Thomas Lockhart <lockhart@alumni.caltech.edu>
Re: [HACKERS] psql and 6.5.3