Re: [GENERAL] ERROR: relation "table" does not exist - HELP

2004-12-11 Thread Ragnar Hafstað
On Sat, 2004-12-11 at 01:54 -0200, itamar wrote: > when I run > > select * from "table" > > I get this error. > > ERROR: relation "table" does not exist The table name is is folded to lowercase, unless it is in quotes. so if the name of the table is TABLE, you need select * from "TABLE" Is

Re: [GENERAL] ERROR: relation "table" does not exist - HELP

2004-12-11 Thread Dann Corbit
That happens when you type: \d From the PSQL sql prompt, like this: connxetl=# \d   List of relations Name  |   Type   |  Owner ---+--+--  ActiveRange   | table    | datasync  Active