RE: psql problem - Mailing list pgsql-sql

From Volker Paul
Subject RE: psql problem
Date
Msg-id 01BFCC72.6AF96310@wpaul.dohle.com
Whole thread Raw
In response to psql problem  (Rick Parker <Rick_Parker@boscomm.net>)
List pgsql-sql
Does anyone know why when I am in a particular DB as user postgres and use
the following statement, why I get this error?" 

This is the statement;
SELECT * FROM some_file where ID = 1;

[Volker Paul]  If your ID field is really uppercase, try:
SELECT * FROM some_file where "ID" = 1;

Cheers,

Volker


pgsql-sql by date:

Previous
From: Brian Powell
Date:
Subject: creating rules on joined views
Next
From: Alessandro Rossi
Date:
Subject: SPEED UP.