pgAdmin Error when trying to run a simple SELECT - Mailing list 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.