Re: Adding SHOW CREATE TABLE

On Sat, May 13, 2023 at 3:34 PM Jeremy Smith <jeremy(at)musicsmith(dot)net> wrote:

>
>
> On Sat, May 13, 2023, 3:25 AM Kirk Wolak <wolakk(at)gmail(dot)com> wrote:
>
>> Does this imply SQL SYNTAX like:
>>
>> SHOW CREATE TABLE <table_name>
>> [ INCLUDING { ALL | INDEXES | SEQUENCES | ??? }]
>> [EXCLUDING { PK | FK | COMMENTS | STORAGE | } ]
>> [FOR {V11 | V12 | V13 | V14 | V15 }] ??
>> ?
>>
>
> Personally, I would expect a function, like pg_get_tabledef(oid), to match
> the other pg_get_*def functions instead of overloading SHOW. To me, this
> also argues that we shouldn't include indexes because we already have a
> pg_get_indexdef function.
>
> -Jeremy
>
+1

In fact, making it a function will make my life easier for testing, that's
for certain. I don't need to involve the parser,etc. Others can help with
that after the function works.
Thanks for the suggestion!