pgAdmin Error when trying to run a simple SELECT

["Brad Smith" <bsmith(at)rdac(dot)com(dot)au>]

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