Web pgadmin.org
 Home 
 ·  ·  ·  ·  ·  ·  · 
pgAdmin Error when trying to run a simple SELECT

pgAdmin Error when trying to run a simple SELECT



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

 

 



Home | Main Index | Thread Index

top