Skip site navigation (1) Skip section navigation (2)

Re: Help with queries...

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Cristian Prieto <cristian(at)clickdiario(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Help with queries...
Date: 2005-02-24 20:44:07
Message-ID: 20050224204406.GA39470@winnie.fuhr.org (view raw or flat)
Thread:
Lists: 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/

In response to

Responses

pgsql-general by date

Next:From: Joshua D. DrakeDate: 2005-02-24 20:49:15
Subject: Re: Help with queries...
Previous:From: Cristian PrietoDate: 2005-02-24 20:33:28
Subject: Help with queries...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group