Re: Adding SHOW CREATE TABLE

On 2023-05-18 Th 19:53, Stephen Frost wrote:
> Greetings,
>
> * Kirk Wolak (wolakk(at)gmail(dot)com) wrote:
>> My approach for now is to develop this as the \st command.
>> After reviewing the code/output from the 3 sources (psql, fdw, and
>> pg_dump). This trivializes the approach,
>> and requires the smallest set of changes (psql is already close with
>> existing queries, etc).
>>
>> And frankly, I would rather have an \st feature that handles 99% of the use
>> cases then go 15yrs waiting for a perfect solution.
>> Once this works well for the group. Then, IMO, that would be the time to
>> discuss moving it.
> Having this only available via psql seems like the least desirable
> option as then it wouldn't be available to any other callers..
>
> Having it in libpq, on the other hand, would make it available to psql
> as well as any other utility, library, or language / driver which uses
> libpq, including pg_dump..
>
> Using libpq would also make sense from the perspective that libpq can be
> used to connect to a number of different major versions of PG and this
> could work work for them all in much the way that pg_dump does.
>
> The downside with this apporach is that drivers which don't use libpq
> (eg: JDBC) would have to re-implement this if they wanted to keep
> feature parity with libpq..

I think the ONLY place we should have this is in server side functions.
More than ten years ago I did some work in this area (see below), but
it's one of those things that have been on my ever growing personal TODO
list

See <https://bitbucket.org/adunstan/retailddl/src/master/> and
<https://www.youtube.com/watch?v=fBarFKOL3SI>

cheers

andrew

--
Andrew Dunstan
EDB:https://www.enterprisedb.com