On Wed, 7 Nov 2001, GB Clark II wrote:
> Hi,
>
> I've got a database that has a column named timestamp.
> Of course is this the same a type and now 7.2 will not allow me to access it
> directly. Any ideas how I can get to the data until I redesign the schema?
>
> Here is an example from it:
>
> helpshop=# select * from customer as C where C.timestamp = '2001-09-09';
> ERROR: parser: parse error at or near "timestamp"
It should be enough to double quote timestamp when you want to refer to
the column.