this not only can be done , but is done - for instance slony does (also) that.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных