Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
From: John Scalia <jayknowsunix@gmail.com>
Mime-Version: 1.0 (1.0)
Subject: Re: Creating a partition table
Message-Id: <72BCF3AA-1931-4BD9-A00D-497B3C2553E2@gmail.com>
Date: Fri, 30 Oct 2020 13:40:21 -0400
Cc: pgsql-admin <pgsql-admin@postgresql.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Precedence: bulk

=EF=BB=BFWell, originally my code had a WITH NO DATA before the PARTITION BY=
 clause, but that was error in as well, but thinking that I would just get s=
tructure of the table that way, the error didn=E2=80=99t make any sense.

I=E2=80=99ll try Laurenz=E2=80=99s code example and see what happens.

Sent from my iPad

> On Oct 30, 2020, at 1:07 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>=20
> =EF=BB=BFJohn Scalia <jayknowsunix@gmail.com> writes:
>> I have a PostgreSQL server version 11.3 that my devs are asking for some p=
artitioned tables. I can=E2=80=99t seem to get the syntax correct though. My=
 SQL code is:
>=20
>> CREATE TABLE schema.temp_table
>> AS (SELECT * FROM schema.original_table)
>> PARTITION BY LIST(attribute_name);
>=20
> You can't create and populate a partitioned table in one command; you have=

> to create some partitions before you can load data into it.
>=20
> I believe you could use CREATE TABLE temp_table (LIKE original_table)
> PARTITION BY LIST(attribute_name) to avoid manually repeating the
> column list.  Check the docs to see which other LIKE options you want
> to use.
>=20
>           regards, tom lane