Partycje na środowisku testowym - skrypt

CREATE TABLE partitions.transaction_2023_03 PARTITION OF public."transaction" FOR VALUES FROM ('2023-03-01 00:00:00') TO ('2024-01-04 00:00:00'); alter table partitions.transaction_2023_03 owner to paybm_admins; CREATE TABLE partitions.params_2023_03 PARTITION OF public.params FOR VALUES FROM ('2023-03-01 00:00:00') TO ('2024-01-04 00:00:00'); alter table partitions.params_2023_03 owner to paybm_admins; CREATE TABLE partitions.notification_2023_03 PARTITION OF public.notification FOR VALUES FROM ('2023-03-01 00:00:00') TO ('2024-01-04 00:00:00'); alter table partitions.notification_2023_03 owner to paybm_admins; CREATE TABLE partitions.notificationid_2023_03 PARTITION OF public.notificationid FOR VALUES FROM ('2023-03-01 00:00:00') TO ('2024-01-04 00:00:00'); alter table partitions.notificationid_2023_03 owner to paybm_admins; CREATE TABLE partitions.fees_2023_03 PARTITION OF public.fees FOR VALUES FROM ('2023-03-01 00:00:00') TO ('2024-01-04 00:00:00'); alter table partitions.fees_2023_03 owner to paybm_admins; CREATE TABLE partitions.product_2023_03 PARTITION OF public.product FOR VALUES FROM ('2023-03-01 00:00:00') TO ('2024-01-04 00:00:00'); alter table partitions.product_2023_03 owner to paybm_admins; CREATE TABLE partitions.balancelog_2023_03 PARTITION OF public."balancelog" FOR VALUES FROM ('2023-03-01 00:00:00') TO ('2024-01-04 00:00:00'); alter table partitions.balancelog_2023_03 owner to paybm_admins;