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
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
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
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:
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
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
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
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.
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
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,
10 matches
Mail list logo