Pgadmin - pgAdmin Error when trying to run a simple SELECT

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

pgAdmin Error when trying to run a simple SELECT

Brad Smith

2005-09-12, 8:24 pm

> 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.

Sponsored Links