Postgres Pro
Downloads
Home   >   mailing lists

Constructing colum name as alias - Mailing list pgsql-sql

From aditya desai
Subject Constructing colum name as alias
Date
Msg-id CAN0SRDH0DhD=WUCbyZ6mG9XGbEyuTaTvaMqoBZc_++7uNxpvrg@mail.gmail.com
Whole thread Raw
Responses Re: Constructing colum name as alias  ("Torsten Grust" <teggy@fastmail.com>)
Re: Constructing colum name as alias  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-sql
Tree view
Hi,
I want to construct column name alias by using different queries. E.g. below.

postgres=# Select ('Status as on '||date_part('day', (SELECT current_timestamp))||'th '||TO_CHAR(current_timestamp, 'Mon'))
postgres-# ;
       ?column?
-----------------------
 Status as on 11th Nov

" Status as on 11th Nov" should be my column name in a query.

SELECT JoiningDate as "Status as on 11th Nov" from empdetails;

How can I achieve this?

Regards,
Aditya.

pgsql-sql by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: How to assign variable in array value inside function proc.
Next
From: "Torsten Grust"
Date:
Subject: Re: Constructing colum name as alias