User and Logical Replication
Hi,
Would it be possible to include the user (who changed the row) in the logical replication data?
Best Reagrds
Tobias
On 2020-03-11 17:18, Tobias Stadler wrote:
Would it be possible to include the user (who changed the row) in the logical replication data?
Not without major re-engineering.
If you need this information, maybe a BEFORE INSERT OR UPDATE trigger
could be used to write this information into a table column.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Tanks for the Info.
Show quoted text
Am 11.03.2020 um 19:01 schrieb Peter Eisentraut <peter.eisentraut@2ndquadrant.com>:
On 2020-03-11 17:18, Tobias Stadler wrote:
Would it be possible to include the user (who changed the row) in the logical replication data?
Not without major re-engineering.
If you need this information, maybe a BEFORE INSERT OR UPDATE trigger could be used to write this information into a table column.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services