From: | "Melvin Davidson" <mdavidson(at)cctus(dot)com> |
---|---|
To: | "Gibson" <gibson(at)nexgenstudio(dot)com>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Select statement doesn't work in Query tool |
Date: | 2006-08-21 15:44:47 |
Message-ID: | 2CC69F840555CB43B04195F218CCB57F44B2D0@COENGEX01.cctus.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Gibson
Sent: Monday, August 21, 2006 1:02 AM
To: pgadmin-support(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Ezequias Rodrigues da Rocha | 2006-08-23 16:47:35 | Problem to install on Fedora 5 |
Previous Message | Dave Page | 2006-08-21 14:52:26 | Re: MSysConf configuration |