| From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Adding SHOW CREATE TABLE |
| Date: | 2023-05-13 05:02:48 |
| Message-ID: | 1aac01a1-d9db-8048-9bfa-1e4f9bb69a03@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Gierth | 2023-05-13 06:18:09 | Re: Window function for get the last value to extend missing rows |
| Previous Message | Stephen Frost | 2023-05-13 00:36:59 | Re: Adding SHOW CREATE TABLE |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2023-05-13 05:31:21 | Re: cutting down the TODO list thread |
| Previous Message | John Naylor | 2023-05-13 04:41:45 | Re: cutting down the TODO list thread |