Re: Clarification regarding CREATE TABLE LIKE and FOREIGN KEYS - Mailing list pgsql-docs

From David G. Johnston
Subject Re: Clarification regarding CREATE TABLE LIKE and FOREIGN KEYS
Date
Msg-id CAKFQuwa=2WOzWWD8OvJgMn3ntG5mt7EJcjcii9Lif87vGbYmcA@mail.gmail.com
Whole thread Raw
In response to Re: Clarification regarding CREATE TABLE LIKE and FOREIGN KEYS  (David Virebayre <david@robbez.com>)
List pgsql-docs
On Fri, Dec 1, 2023 at 7:07 AM David Virebayre <david@robbez.com> wrote:
"INCLUDING ALL" leads people to believe *everything* is copied. 

The fact that it doesn't seem counter intuitive, at least to me.

Therefore, it doesn't seem absurd to me to warn people about what is not copied.

I wrote the original message hoping to help improve the documentation. I could write a draft if I'm allowed to.
I do believe that clarifying this point improves the documentation. If there's a consensus that it doesn't, my apologies for the annoyance.


You are welcome to suggest improvements.  But "all" means inclusive of every individual item listed on that page.  You don't get stuff in "all" that you cannot specify individually and you cannot specify references clauses individually.

David J.

pgsql-docs by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: Restore to a new database from a backup (.tar) generated from
Next
From: PG Doc comments form
Date:
Subject: libpq-ssl suggestion: