Re: Help with queries...

Cristian Prieto wrote:

> Why do I need to add "" to a table when doing a query? I've checked
> the examples and I found no one has " around the table names. It is
> something with the configuration?
> If I do:
>
> select * from users;
> ERROR:  relation "users" does not exist
>
> but:
> select * from "Users";
> returns all the data I want...
>
> Right now I'm using postgresql 8.0.1

Because PostgreSQL folds all non quoted relation names to lowercase.
It is best just to have your relations be lowercase and then you don't
have to quote.

Sincerely,

Joshua D. Drake


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL