Home > mailing lists

Re: Lack of possibility to specify CTAS TAM - Mailing list pgsql-hackers

From	David G. Johnston
Subject	Re: Lack of possibility to specify CTAS TAM
Date	July 31 10:15:18
Msg-id	CAKFQuwai4_dfAGP-MOM+bQegeUhS9v6B-rxv3DPAvTqNpne-qg@mail.gmail.com Whole thread Raw
In response to	Lack of possibility to specify CTAS TAM (Kirill Reshke <reshkekirill@gmail.com>)
Responses	Re: Lack of possibility to specify CTAS TAM
List	pgsql-hackers

On Wednesday, July 31, 2024, Kirill Reshke <reshkekirill@gmail.com> wrote:

I have noticed $subj while working with other unrelated patches.
The question is, why there is no CREATE TABLE AS .... USING
(some_access_method)?

The syntax is documented…

CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name    [ (column_name [, ...] ) ]    [ USING method ]

… AS query

David J.

From: "Andrey M. Borodin"
Date: 31 July, 10:12:35
Subject: Re: Lack of possibility to specify CTAS TAM

From: Kirill Reshke
Date: 31 July, 10:20:10
Subject: Re: Lack of possibility to specify CTAS TAM