Subject: Re: Lack of possibility to specify CTAS TAM

From: "David G. Johnston" <[email-masked]>
Date: Wed, 31 Jul 2024 00:15:18 -0700

On Wednesday, July 31, 2024, Kirill Reshke <[email-masked]> 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.