Constructing colum name as alias

From: aditya desai <admad123(at)gmail(dot)com>
To: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Constructing colum name as alias
Date: 2021-11-11 07:46:08
Message-ID: CAN0SRDH0DhD=WUCbyZ6mG9XGbEyuTaTvaMqoBZc_++7uNxpvrg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Torsten Grust 2021-11-11 11:10:31 Re: Constructing colum name as alias
Previous Message David G. Johnston 2021-11-01 16:53:34 Re: How to assign variable in array value inside function proc.