Postgres Pro
Downloads
Home   >   mailing lists

Thread: Table recognition

Table recognition

From
Peter Rodriguez
Date:
I have PostgreSQL installed on my stand-alone machine with RedHat 6.2. I have created several tables in one database using Pgaccess and have no problems using them through the GUI. However, when I try to use the psql interface, although it successfully lists the tables, when I try to operate on them, I get the error message  "..table does not exist". Maybe I am missing something - any suggestions, please? 
-- 
Peter Rodriguez 
2/219, St. George Street, Papatoetoe     
Auckland, NEW ZEALAND
 

Re: Table recognition

From
Tom Lane
Date:
Peter Rodriguez <pfrodri@attglobal.net> writes:
> I have PostgreSQL installed on my stand-alone machine with RedHat 6.2. I
> have created several tables in one database using Pgaccess and have no
> problems using them through the GUI. However, when I try to use the psql
> interface, although it successfully lists the tables, when I try to
> operate on them, I get the error message  "..table does not exist".
> Maybe I am missing something - any suggestions, please?

Are you using mixed-case table names?  I think pgaccess will double
quote all names for you ... but psql won't, which means your table
names had better be lower case if you don't want to type quotes all
the time.

            regards, tom lane