dynamic partition table inserts

From: Ted Toth <txtoth(at)gmail(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: dynamic partition table inserts
Date: 2023-01-25 13:38:02
Message-ID: CAFPpqQFDAJy=E3N5zPQVrb7F0dLhwiLp7N=HKB9-1dFdRciRHQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm creating partition tables on the fly following the technique described
in https://minervadb.com/index.php/postgresql-dynamic-partitioning/ .
Regardless of whether a partition table is created or already exists all I
really want to do is change the destination table (TG_TABLE_NAME?) of the
insert to the partition table. Is this possible or is my only option to
generate a new insert as in the example?

Ted

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Николай Кобзарев 2023-01-25 16:49:13 Re: dynamic partition table inserts
Previous Message Wiwwo Staff 2023-01-25 09:57:37 Re: pg_rewind and user / passfile