Re: Constructing colum name as alias

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: aditya desai <admad123(at)gmail(dot)com>
Cc: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Re: Constructing colum name as alias
Date: 2021-11-11 13:19:45
Message-ID: CAKFQuwbbBanTecKXa=ejrYmSoPADT6OdJwnkzOqn-onAhyff-A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thursday, November 11, 2021, aditya desai <admad123(at)gmail(dot)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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Theodore M Rolle, Jr. 2021-11-11 13:22:48 Re: Constructing colum name as alias
Previous Message Torsten Grust 2021-11-11 11:10:31 Re: Constructing colum name as alias