Postgres Pro
Downloads
Home   >   mailing lists

Select statement doesn't work in Query tool - Mailing list pgadmin-support

From Gibson
Subject Select statement doesn't work in Query tool
Date
Msg-id 44E95A79.5060502@nexgenstudio.com
Whole thread Raw
Responses Re: Select statement doesn't work in Query tool  ("Melvin Davidson" <mdavidson@cctus.com>)
List pgadmin-support
Tree view 
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>

pgadmin-support by date:

Previous
From: Henry Andres Sanabria Fuentes
Date:
Subject: Re: How to add a function that returns the result of a select statement?
Next
From: "Ezequias Rodrigues da Rocha"
Date:
Subject: How to make a replication