"Cristian Prieto" <[EMAIL PROTECTED]> writes:
> The book says:
> [snip]
> 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";
You didn't read far enough:
Quoti
- Original Message - From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "Cristian Prieto" <[EMAIL PROTECTED]>
Cc:
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 wrot
PROTECTED]>
To: "Cristian Prieto" <[EMAIL PROTECTED]>
Cc:
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
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 par
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";
re
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
