table does not exist

Hello,

I have installed postgresql version 6.4.2 on a Red Hat Linux 6.0 box. I
have it up and running.

I have used pgaccess to create some tables, and enter some data into
them, but when i run a query I get the following message: <tablename>:
Table does not exist.

my table name is COMPANIES

I am using the following query: SELECT ID, NAME FROM COMPANIES

I run a \dt from the psql interface and my tables show up, but I can not
query them. Is there an administrative step I must do first?

Thanks

Tim Stevens

Tim Stevens
Genesis Networks, Inc.
3943 South 48th Street, Lincoln, NE 68506
Phone 402-488-6468
fax 402-488-6535
E-mail tstevens(at)genesisnets(dot)com