Re: create table like: ACCESS METHOD - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: create table like: ACCESS METHOD
Date
Msg-id YVbAXQc9oaIYfkN1@paquier.xyz
Whole thread Raw
In response to Re: create table like: ACCESS METHOD  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
List pgsql-hackers
On Thu, Sep 09, 2021 at 02:30:51PM +0200, Peter Eisentraut wrote:
> Hmm.  The problem is that the LIKE clause is really a macro that expands to
> the column definitions of the other table.  So there is, so far, no such as
> thing as two LIKE clauses contradicting.  Whereas the access method is a
> table property.  So I don't think this syntax is the right approach for this
> feature.
>
> You might think about something like
>
> CREATE TABLE t2 (...) USING (LIKE t1);
>
> At least in terms of how the syntax should be structured.

Good point.  I have marked the patch as RwF.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Re: Allow escape in application_name
Next
From: Greg Nancarrow
Date:
Subject: Re: Logical replication keepalive flood