Re: Adding SHOW CREATE TABLE

On Sat, May 13, 2023, 3:25 AM Kirk Wolak <wolakk@gmail.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

>
>