| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | stercor(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 14:16:12 |
| Message-ID: | CAKFQuwb9FkB1HcwU0KNnxqGFe-GEoH3BEq+gv=x4J4=+V854vw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | chris | 2021-11-11 14:23:57 | Re: Constructing colum name as alias |
| Previous Message | David G. Johnston | 2021-11-11 14:14:53 | Re: Constructing colum name as alias |