继承

继承：

http://www.postgresql.org/docs/9.3/static/ddl-inherit.html

分区表：

http://www.postgresql.org/docs/9.3/static/ddl-partitioning.html

分区表需要和trigger一起使用才可。

CREATE TABLE measurement (
    city_id         int not null,
    logdate         int,
    peaktemp        int,
    unitsales       int
);
CREATE TABLE measurement_y2006m02 (
    CHECK ( logdate >=   0 AND logdate <   20 )
) INHERITS (measurement);
CREATE TABLE measurement_y2006m03 (
    CHECK ( logdate >=   20 AND logdate <   40 )
) INHERITS (measurement);
CREATE TABLE measurement_y2007m12 (
    CHECK ( logdate >=   40 )
) INHERITS (measurement);
CREATE TABLE measurement_y2005m02 (
    CHECK ( logdate >=   -20 AND logdate <   0 )
) INHERITS (measurement);
CREATE OR REPLACE FUNCTION measurement_insert_trigger()
RETURNS TRIGGER AS $$
BEGIN
    IF ( NEW.logdate >=   0 AND
         NEW.logdate <   20 ) THEN
        INSERT INTO measurement_y2006m02 VALUES (NEW.*);
    ELSIF ( NEW.logdate >=   20 AND
            NEW.logdate <   40 ) THEN
        INSERT INTO measurement_y2006m03 VALUES (NEW.*);
    --...
    ELSIF ( NEW.logdate >=   -20 AND
            NEW.logdate <   0 ) THEN
        INSERT INTO measurement_y2005m02 VALUES (NEW.*);
    ELSE
        RAISE EXCEPTION 'Date out of range.  Fix the measurement_insert_trigger() function!';
    END IF;
    RETURN NULL;
END;
$$
LANGUAGE plpgsql;
CREATE TRIGGER insert_measurement_trigger
    BEFORE INSERT ON measurement
    FOR EACH ROW EXECUTE PROCEDURE measurement_insert_trigger();
insert into measurement values(1,1,1,1);
select * from only measurement;
select * from only only measurement;
select * from measurement_y2006m02;