PostgreSQL パーティションテーブル

リストパーティションテーブル

create table postal_code_list (
 prefecture_code      varchar(2)
,jis_address_cd       varchar(5)
,postal_code_old      varchar(5)
,postal_code          varchar(7)
,prefecture_kana      varchar(20)
,shikucyoson_kana     varchar(40)
,cyoiki_kana          varchar(160)
,prefecture           varchar(20)
,shikucyoson          varchar(40)
,cyoiki               varchar(160)
,multiple_postal_div  varchar(1)
,koaza_div            varchar(1)
,cyome_div            varchar(1)
,multiple_regions_div varchar(1)
,update_div           varchar(1)
,reason_div           varchar(1)
)  PARTITION BY LIST (prefecture_code)
;
CREATE TABLE P01_hokkaido PARTITION OF postal_code_list FOR VALUES IN('01');
CREATE TABLE P02_aomori   PARTITION OF postal_code_list FOR VALUES IN('02');
CREATE TABLE P03_iwate    PARTITION OF postal_code_list FOR VALUES IN('03');
CREATE TABLE P99_default  PARTITION OF postal_code_list DEFAULT;

CREATE TABLE P01_hokkaido PARTITION OF postal_code_list FOR VALUES IN('01');
CREATE TABLE P02_aomori   PARTITION OF postal_code_list FOR VALUES IN('02');
CREATE TABLE P03_iwate    PARTITION OF postal_code_list FOR VALUES IN('03');
CREATE TABLE P99_default  PARTITION OF postal_code_list DEFAULT;