Re: Select statement doesn't work in Query tool

Gibson,

Check that the schema is in the default path.
eg: SHOW SEARCH_PATH;

If not, either set the path to include it,
or specify the schema with the table.
eg:  Select * from <your_schema>.user;

-----Original Message-----
From: pgadmin-support-owner@postgresql.org
[mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Gibson
Sent: Monday, August 21, 2006 1:02 AM
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Select statement doesn't work in Query tool

Hi,

I have 1 record in the user table, but upon using the "Select * from
user" statement, the statement doesn't return a single record in the
query tool. Then when i use "Select * from user where membername =
'hey') where membername is a valid column and 'hey' is a valid record, i
get a 'column "membername" does not exist' error which should not exist
since the column "MemberName" is inside the "User" table too. Can anyone
help me?
--

Cheers
Gibson Tang
Game Programmer
179, River Valley Building #04-09
Singapore 179033
Nexgen Studio <www.nexgenstudio.com>

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend