But my table name Grupos is not a reserved keyword, so SELECT * FROM Grupos; should work, right??? but guess what... It doesn't work too... I need to pass SELECT * FROM "Grupos";
That is correct. Because you have a capital letter in the table name.
Sincerely,
Joshua D. Drake
----- Original Message ----- From: "Michael Fuhr" <mike@xxxxxxxx> To: "Cristian Prieto" <cristian@xxxxxxxxxxxxxxx> Cc: <pgsql-general@xxxxxxxxxxxxxx> Sent: Thursday, February 24, 2005 2:44 PM Subject: 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/
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
-- 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 8: explain analyze is your friend
