Обсуждение: Table recognition

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

 

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