Re: pgAdmin Error when trying to run a simple SELECT

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Brad Smith <bsmith(at)rdac(dot)com(dot)au>
Cc: <pgadmin-support(at)postgresql(dot)org>
Subject: Re: pgAdmin Error when trying to run a simple SELECT
Date: 2005-09-12 11:01:29
Message-ID: A2F2279C-2544-46BF-B666-4AAA13D8BD81@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support


On Sep 12, 2005, at 5:53 AM, Brad Smith wrote:

> My problem is this: Whenever I try to run an SQL statement like:
>
> SELECT * from refUSERS;
>
> I get an error:
>
> ERROR: Relation "refusers" does not exist.
PostgreSQL folds unquoted identifiers to lower case. So if your
select has the correct spelling you need to use:

SELECT * from "refUSERS";

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message miwalsh 2005-09-12 16:55:04 problems installing pgadminIII
Previous Message Brad Smith 2005-09-12 09:53:49 pgAdmin Error when trying to run a simple SELECT