Clarification regarding CREATE TABLE LIKE and FOREIGN KEYS

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: david(at)robbez(dot)com
Subject: Clarification regarding CREATE TABLE LIKE and FOREIGN KEYS
Date: 2023-11-27 15:05:25
Message-ID: 170109752554.398199.1576920096317923086@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/16/sql-createtable.html
Description:

It is not clear to me that foreign keys are copied or not when duplicating a
table using CREATE TABLE ... LIKE ... INCLUDING ALL. I had to actually test
to check what it does.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Erik Wienhold 2023-11-27 15:52:20 Re: [DOCS] Add example about date ISO format
Previous Message Nikolay Samokhvalov 2023-11-27 14:57:24 CONCURRENTLY in example of index of partitioned table