Postgres Pro
Downloads
Home   >   mailing lists

Re: Constructing colum name as alias - Mailing list pgsql-sql

From David G. Johnston
Subject Re: Constructing colum name as alias
Date
Msg-id CAKFQuwbbBanTecKXa=ejrYmSoPADT6OdJwnkzOqn-onAhyff-A@mail.gmail.com
Whole thread Raw
In response to Constructing colum name as alias  (aditya desai <admad123@gmail.com>)
Responses Re: Constructing colum name as alias  ("Theodore M Rolle, Jr." <stercor@gmail.com>)
List pgsql-sql
Tree view
On Thursday, November 11, 2021, aditya desai <admad123@gmail.com> wrote:

" 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?

Dynamic SQL and two independent queries.  One to get the column name.  Then a dynamic one  (say using pl/pgsql) that uses that name.

David J.

pgsql-sql by date:

Previous
From: "Torsten Grust"
Date:
Subject: Re: Constructing colum name as alias
Next
From: "Theodore M Rolle, Jr."
Date:
Subject: Re: Constructing colum name as alias