Re: first message: SELECT <column> FROM <t

From: Garry Saddington <garry(at)schoolteachers(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: first message: SELECT <column> FROM <t
Date: 2008-02-03 00:27:39
Message-ID: 200802030027.39896.garry@schoolteachers.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Saturday 02 February 2008 17:43, Aílsom F. Heringer wrote:
> Hi,
> This is my first message, and I need some help. I have just installed
> Postgresql 8.2. (Windows).
>
> At pgAdmin III Query, when I send SELECT * FROM USUARIOS, I get all
> columns correctly. But when I try to get only one column, SELECT senha
> FROM USUARIOS, I get the error message:
>
> ERROR: column "senha" does not exist
> SQL state: 42703
> Character: 8
>
> What is the problem ?
Please post your table definition so that we can see what you are selecting
from. If you were one of my students I would say "check your table definition
or your spelling".
Regards
Garry

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Browne 2008-02-03 01:45:35 Re: Request for help with database of Kenyan election violence
Previous Message Karsten Hilbert 2008-02-02 22:52:00 Re: [OT] "advanced" database design (long)