Re: Adding SHOW CREATE TABLE
Ron Johnson <ronljohnsonjr@gmail.com>
From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-general@lists.postgresql.org
Date: 2023-05-13T05:02:48Z
Lists: pgsql-hackers, pgsql-general
On 5/12/23 18:00, Kirk Wolak wrote:
[snip]
> Where do we draw the lines?
At other tables.
> Does Table DDL include all indexes?
Absolutely!
> It should include constraints, clearly. I would not think it should have
> triggers.
Definitely triggers. And foreign keys.
> Literally everything within the <<CREATE TABLE X(...);>>. (ie, no ALTER
> .. OWNER TO...)
>
ALTER statements, too. If CREATE TABLE ... LIKE ... { INCLUDING | EXCLUDING
} { COMMENTS | COMPRESSION | CONSTRAINTS | DEFAULTS | GENERATED | IDENTITY |
INDEXES | STATISTICS | STORAGE | ALL } can do it, then so should SHOW CREATE
TABLE.
--
Born in Arizona, moved to Babylonia.