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/