Postgres Pro
Downloads
Home   >   mailing lists

Naming columns for SQL output ... - Mailing list pgsql-general

From Jim Richards
Subject Naming columns for SQL output ...
Date
Msg-id 199909240138.VAA93570@hub.org
Whole thread Raw
In response to Backend crashed with status 139 ( may be long SQL query)  ("Natalya S. Makushina" <mak@rtsoft.msk.ru>)
Responses Re: [GENERAL] Naming columns for SQL output ...
List pgsql-general
Tree view 
Hello all ...

How do I name a column in an SQL query. In Oracle I would use

    select now() 'the time now';

how is this done in PostgreSQL?

Thanks ...


----
CyberCyberCyberCyber Pty Ltd
 http://www.cyber4.org/cyber4/index.html
  New Media For The New Millennium

pgsql-general by date:

Previous
From: Paul Kelly
Date:
Subject: pl/pgsql
Next
From: "Aaron J. Seigo"
Date:
Subject: Re: [GENERAL] Naming columns for SQL output ...