Re: [GENERAL] first message: SELECT FROM

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

Re: [GENERAL] first message: SELECT FROM

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 Sc

Re: [GENERAL] first message: SELECT FROM

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 FROM

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

Re: [GENERAL] first message: SELECT FROM

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(),

Re: [GENERAL] first message: SELECT FROM

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 o

Re: [GENERAL] first message: SELECT FROM

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 stat

Re: [GENERAL] first message: SELECT FROM

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 FROM

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

[GENERAL] first message: SELECT FROM

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 "se