Pgadmin - pgAdmin Error when trying to run a simple SELECT

Author

pgAdmin Error when trying to run a simple SELECT

Brad Smith

2005-09-12, 7:26 am

HelloCan anyone help with an error I'm suddenly getting in PgAdmin II.

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.

I've tried other simple SELECT statements but get the same message.

I can't for the life of me understand what's changed.

I can use other databases using the same login credentials and login
procedures and the error does not occur when using them; it only seems
to occur with this particular database. I can 'see' the database fine in
the Menu Tree. I can drill down to the tables and I can see the table
data by clicking on the Sunglasses icon - I just can't seem to run a
basic query.

Can any one help/suggest anything at all? Do I need to prefix the table
name with something? (although I never had to before)

Brad.

John DeSoi

2005-09-12, 7:26 am

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

Sponsored Links