View Single Post

   
  #2 (permalink)  
Old 04-17-2008, 07:08 PM
John DeSoi
 
Posts: n/a
Default Re: pgAdmin Error when trying to run a simple SELECT


On Sep 12, 2005, at 5:53 AM, Brad Smith wrote:

> 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


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply With Quote