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