Postgres Pro
Downloads
Home   >   mailing lists

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

From Theodore M Rolle, Jr.
Subject Re: Constructing colum name as alias
Date
Msg-id CAPDmd-DOAMRhiQskxOh9UZGOcNXCvUdY2tTdcvggOTXyXaebEQ@mail.gmail.com
Whole thread Raw
In response to Re: Constructing colum name as alias  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Constructing colum name as alias
List pgsql-sql
Tree view
May we have an example?

On Thu, Nov 11, 2021, 08:19 David G. Johnston <david.g.johnston@gmail.com> wrote:
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: "David G. Johnston"
Date:
Subject: Re: Constructing colum name as alias
Next
From: "David G. Johnston"
Date:
Subject: Re: Constructing colum name as alias