Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
From: John Scalia <jayknowsunix@gmail.com>
Mime-Version: 1.0 (1.0)
Date: Fri, 30 Oct 2020 12:52:49 -0400
Subject: Creating a partition table
Message-Id: <BFBB87D2-4AFB-4B2A-A140-E19860849936@gmail.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Precedence: bulk

Hi all,

I have a PostgreSQL server version 11.3 that my devs are asking for some par=
titioned tables. I can=E2=80=99t seem to get the syntax correct though. My S=
QL code is:

CREATE TABLE schema.temp_table
AS (SELECT * FROM schema.original_table)
PARTITION BY LIST(attribute_name);

As what I want to do is create a copy of the current table, create the parti=
tions on the new temp table, and when everything works, drop the original ta=
ble and do an alter table rename on the new one.

The error is:
ERROR: syntax error at or near =E2=80=9CPARTITION=E2=80=9D
Line 3: PARTITION BY LIST(attribute_name);

I=E2=80=99ve tried using the word RANGE as opposed to LIST, but the error re=
mains. Does PostgreSQL not support a construct like this one or am I doing s=
omething wrong?
=E2=80=94
Jay

Sent from my iPad=