Re: [GENERAL] Naming columns for SQL output ...

From: "Aaron J(dot) Seigo" <aaron(at)gtv(dot)ca>
To: Jim Richards <grumpy(at)cyber4(dot)org>, pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Naming columns for SQL output ...
Date: 1999-09-24 02:12:34
Message-ID: 99092320130807.00552@stilborne
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi..

> 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?
>
if i understand your question:

select now() as 'the time now';

--
Aaron J. Seigo
Sys Admin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sofian Lutfi 1999-09-24 03:34:29
Previous Message Jim Richards 1999-09-24 01:37:43 Naming columns for SQL output ...