Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Postgres Auditing in 150 lines of SQL. Parent comment
``` alter table audit.record_version add column user_id bigint default (coalesce(record, old_record) ->> 'user_id'); ```
or if you meant the SQL `current_user` you could extend the trigger to track it.
but if the user_id is only available in application space (not in the db) it will not be possible using straight SQL
There are no comments on this comment yet.
``` alter table audit.record_version add column user_id bigint default (coalesce(record, old_record) ->> 'user_id'); ```
or if you meant the SQL `current_user` you could extend the trigger to track it.
but if the user_id is only available in application space (not in the db) it will not be possible using straight SQL