pgAdmin Error when trying to run a simple SELECT

From: "Brad Smith" <bsmith(at)rdac(dot)com(dot)au>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: pgAdmin Error when trying to run a simple SELECT
Date: 2005-09-13 00:57:19
Message-ID: A51777EE23640141A17640B11E6637FA036927@rdaex01.rdac.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

> 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

John,

Thank-you. You solved my problem!

Sincerely,

Brad Smith.

Browse pgadmin-support by date

  From Date Subject
Next Message blacknoz 2005-09-13 08:51:39 pgAdmin III 1.2.2 uploaded to debian/unstable
Previous Message miwalsh 2005-09-12 16:55:04 problems installing pgadminIII