CREATE TABLE measurement (
    city_id         int not null,
    logdate         date not null,
    peaktemp        int,
    unitsales       int
);

CREATE TABLE measurement_yy04mm02 (
    CHECK ( logdate >= DATE '2004-02-01' AND logdate < DATE '2004-03-01' )
) INHERITS (measurement);

CREATE RULE measurement_insert_yy04mm02 AS
ON INSERT TO measurement WHERE
    ( logdate >= DATE '2004-02-01' AND logdate < DATE '2004-03-01' )
DO INSTEAD
    INSERT INTO measurement_yy04mm02 VALUES ( NEW.city_id,
                                              NEW.logdate,
                                              NEW.peaktemp,
                                              NEW.unitsales );

REVOKE ALL ON measurement FROM inserter;
GRANT ON INSERT measurement TO inserter;

REVOKE ALL ON measurement FROM selector;
GRANT ON SELECT measurement TO selector;

psql db_name inserter -c "\copy measurement from filename.txt"

select * from measurement LIMIT  10 ;
Permission denied for relation measurement_yy04mm02