Re: [GENERAL] Naming columns for SQL output ... - Mailing list 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