Re: Lack of possibility to specify CTAS TAM

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Kirill Reshke <reshkekirill(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Lack of possibility to specify CTAS TAM
Date: 2024-07-31 07:15:18
Message-ID: CAKFQuwai4_dfAGP-MOM+bQegeUhS9v6B-rxv3DPAvTqNpne-qg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wednesday, July 31, 2024, Kirill Reshke <reshkekirill(at)gmail(dot)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

https://www.postgresql.org/docs/current/sql-createtableas.html

David J.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kirill Reshke 2024-07-31 07:20:10 Re: Lack of possibility to specify CTAS TAM
Previous Message Andrey M. Borodin 2024-07-31 07:12:35 Re: Lack of possibility to specify CTAS TAM