Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

postgres automatic partioning a table

alter table myTable rename to myTable_old;

create table myTable_master(
    forDate date not null,
    key2 int not null,
    value int not null
) partition by range (forDate);
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #postgres #automatic #partioning #table
ADD COMMENT
Topic
Name
5+2 =