Re: Help with queries... - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Help with queries...
Date
Msg-id 20050224204406.GA39470@winnie.fuhr.org
Whole thread Raw
In response to Help with queries...  ("Cristian Prieto" <cristian@clickdiario.com>)
List pgsql-general
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/

pgsql-general by date:

Previous
From: "Cristian Prieto"
Date:
Subject: Help with queries...
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Help with queries...