Thread: Re: [HACKERS] psql and 6.5.3

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

> 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