how to add a partition to table in postgres

Hapless Hacker answered on February 2, 2024 Popularity 7/10 Helpfulness 5/10

answer how to add a partition to table in postgres

Comment

create table schema_name.partition_name partition of schema_name.table_name
for values from ('2024-02-01') to ('2024-03-01');

Popularity 7/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: add partition sql

Link to this answer
Share Copy Link

Contributed on Feb 02 2024

Hapless Hacker

0 Answers Avg Quality 2/10

Oops, You will need to install Grepper and log-in to perform this action.