Re: Clarification regarding CREATE TABLE LIKE and FOREIGN KEYS

2023-12-01 Thread David G. Johnston
On Fri, Dec 1, 2023 at 7:07 AM David Virebayre 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 origi

Re: Clarification regarding CREATE TABLE LIKE and FOREIGN KEYS

2023-12-01 Thread David Virebayre
Le mer. 29 nov. 2023 à 16:24, Euler Taveira a écrit : > On Mon, Nov 27, 2023, at 12:05 PM, PG Doc comments form wrote: > > 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

Re: Restore to a new database from a backup (.tar) generated from

2023-12-01 Thread Daniel Gustafsson
> On 29 Nov 2023, at 23:18, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/15/app-pgrestore.html > Description: > > After creating a new database in postgreSQL : This fo