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: (view raw, whole thread or download thread mbox)
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:

Michael Fuhr

In response to


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-2017 The PostgreSQL Global Development Group