Re: Help with queries...

>
> 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@fuhr.org>
> To: "Cristian Prieto" <cristian@clickdiario.com>
> Cc: <pgsql-general@postgresql.org>
> Sent: Thursday, February 24, 2005 2:44 PM
> Subject: Re: [GENERAL] 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@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL