Select statement doesn't work in Query tool

From: Gibson <gibson(at)nexgenstudio(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Select statement doesn't work in Query tool
Date: 2006-08-21 07:02:17
Message-ID: 44E95A79.5060502@nexgenstudio.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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>

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Ezequias Rodrigues da Rocha 2006-08-21 12:16:51 How to make a replication
Previous Message Henry Andres Sanabria Fuentes 2006-08-19 01:51:28 Re: How to add a function that returns the result of a select statement?