On Thu, Feb 24, 2005 at 02:33:28PM -0600, Cristian Prieto wrote: > select * from users; > ERROR: relation "users" does not exist > > but: > select * from "Users"; > returns all the data I want...
See "Identifiers and Keywords" in the "SQL Syntax" chapter of the documentation, especially the parts that talk about case and quoting: http://www.postgresql.org/docs/8.0/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
