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@xxxxxxxxxxxxxxxxx - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL
begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:jd@xxxxxxxxxxxxxxxxx title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 x-mozilla-html:FALSE url:http://www.commandprompt.com version:2.1 end:vcard
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
