Re: Constructing colum name as alias

From: "Theodore M Rolle, Jr(dot)" <stercor(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: aditya desai <admad123(at)gmail(dot)com>, pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Re: Constructing colum name as alias
Date: 2021-11-11 13:22:48
Message-ID: CAPDmd-DOAMRhiQskxOh9UZGOcNXCvUdY2tTdcvggOTXyXaebEQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

May we have an example?

On Thu, Nov 11, 2021, 08:19 David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
wrote:

> 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 David G. Johnston 2021-11-11 14:14:53 Re: Constructing colum name as alias
Previous Message David G. Johnston 2021-11-11 13:19:45 Re: Constructing colum name as alias