Re: Help with queries...

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/