在Postgres中攀登父/子数据库关系

CREATE TABLE parent_table (
    id SERIAL PRIMARY KEY,
    column1 TYPE,
    column2 TYPE,
    ...
);

CREATE TABLE child_table (
    id SERIAL PRIMARY KEY,
    parent_id INTEGER REFERENCES parent_table(id),
    column1 TYPE,
    column2 TYPE,
    ...
);

CREATE TABLE partitioned_table (
    CHECK (condition),
    LIKE parent_table INCLUDING ALL
) INHERITS (parent_table);

CREATE OR REPLACE FUNCTION insert_into_child_table()
RETURNS TRIGGER AS $$
BEGIN
    INSERT INTO child_table VALUES (NEW.*);
    RETURN NEW;
END;
$$ LANGUAGE plpgsql;

CREATE TRIGGER insert_child_table_trigger
AFTER INSERT ON parent_table
FOR EACH ROW
EXECUTE FUNCTION insert_into_child_table();

INSERT INTO parent_table (column1, column2, ...) VALUES (value1, value2, ...);