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 this your problem ? gnari ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match