Re: Constructing colum name as alias

A flexible way to application, don’t know the actually value🤦‍♂️ see below：

select * from (Select ('Status as on '||date_part('day', (SELECT current_timestamp))||'th '||TO_CHAR(current_timestamp, 'Mon'))
union all
select now()::text from t1) foo limit 11;

Regards,
Chris
On 11/11/2021 22:16，David G. Johnston<david(dot)g(dot)johnston(at)gmail(dot)com> wrote：
On Thu, Nov 11, 2021 at 7:14 AM David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

On Thu, Nov 11, 2021 at 6:23 AM Theodore M Rolle, Jr. <stercor(at)gmail(dot)com> wrote:

May we have an example?

Here are the docs detailing writing dynamic SQL commands in pl/pgsql.

https://www.postgresql.org/docs/current/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN

Though, as you probably want to see these columns in your application you will probably need to translate the concept to whatever programming language and database client interface you are using.

David J.