I have a schema with a generated table with information coming from batch
processes.

I would like to store in that table manually generated information. Since
those rows are inserted by hand, they will be lost when the table will be
reimported.

So I was thinking of creating a partitioned table with a column "origin" to
select if the data is batch inserted or inserted by hand. Current generated
by batch sub-table will live in its schema.

I want the other sub-table containing manually inserted information living
in another schema.

Is this possible? Do I have to do something else (create some trigger, or
something)?

Something like:

CREATE TABLE *automatic.*measurement (
    city_id         int not null,
    logdate         date not null,
    peaktemp        int,
    unitsales       int
    origin          int
) PARTITION BY RANGE (origin);


CREATE TABLE *automatic.*measurement_automatic PARTITION OF
*automatic.*measurement
    FOR VALUES FROM (1) TO (1)
    PARTITION BY RANGE (origin);

CREATE TABLE *manual.*measurement_manual PARTITION OF *automatic.*measurement
    FOR VALUES FROM (2) TO (2)
    PARTITION BY RANGE (origin);

Reply via email to