[GENERAL] first message: SELECT column FROM t

2008-02-02 Thread Aílsom F. Heringer
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

Re: [GENERAL] first message: SELECT column FROM t

2008-02-02 Thread Bill Moran
On Sat, 2 Feb 2008 15:43:15 -0200 Aílsom F. Heringer [EMAIL PROTECTED] 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

Re: [GENERAL] first message: SELECT column FROM t

2008-02-02 Thread Raymond O'Donnell
On 02/02/2008 17:43, Aílsom F. Heringer wrote: 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

Re: [GENERAL] first message: SELECT column FROM t

2008-02-02 Thread Ragnar
On lau, 2008-02-02 at 15:43 -0200, Aílsom F. Heringer wrote: 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:

Re: [GENERAL] first message: SELECT column FROM t

2008-02-02 Thread Scott Marlowe
On Feb 2, 2008 11:43 AM, Aílsom F. Heringer [EMAIL PROTECTED] 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

Re: [GENERAL] first message: SELECT column FROM t

2008-02-02 Thread Aílsom F. Heringer
Bill, The collumn is defined as Senha, and I am sending SELECT Senha FROM Usuarios. Below, the table definition from SQL Pane: CREATE TABLE usuarios ( CdUsuario character(6) NOT NULL, NmUsuario character(15) NOT NULL, DtCadastro timestamp without time zone NOT NULL DEFAULT now(), StSuper

Re: [GENERAL] first message: SELECT column FROM t

2008-02-02 Thread Aílsom F. Heringer
Ok. That was the problem. Now SELECT Senha FROM USUARIOS is working fine. But, At an application using ODBC connection I will need to send Senha too ? Aílsom 2008/2/2, Ragnar [EMAIL PROTECTED]: On lau, 2008-02-02 at 15:43 -0200, Aílsom F. Heringer wrote: At pgAdmin III Query, when I send

Re: [GENERAL] first message: SELECT column FROM t

2008-02-02 Thread Raymond O'Donnell
On 02/02/2008 17:59, Aílsom F. Heringer wrote: The collumn is defined as Senha, and I am sending SELECT Senha FROM [] CREATE TABLE usuarios ( [] Senha character(10), [] There you go - you need to do select Senha Ray.

Re: [GENERAL] first message: SELECT column FROM t

2008-02-02 Thread Alban Hertroys
On Feb 2, 2008, at 6:56 PM, Bill Moran wrote: preserved that. PostgreSQL is case-sensative, so try matching the column name exactly and putting around it. If that doesn't work, provide some That is just plain incorrect, PostgreSQL is *not* case sensitive. The real problem here (as

Re: [GENERAL] first message: SELECT column FROM t

2008-02-02 Thread Garry Saddington
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,