Anton Nikiforov wrote:
Could somene supply me with a solution or documentation part that i
should read?
Can't remember which part it is, but you want one of:
SELECT CURRENT_USER;
SELECT SESSION_USER;
test=# SELECT CURRENT_USER;
current_user
--
anton
(1 row)
test=# SELECT SESSION
Thanks for the replay, Richard.
Richard Huxton wrote:
Anton Nikiforov wrote:
Dear All,
I have made a trigger procedure that logs all table's changes to the
log_table in XML format, but i do need to log a user who did that and
not succsessful with this.
The documentation (including "37.10. Trigger
Anton Nikiforov wrote:
Dear All,
I have made a trigger procedure that logs all table's changes to the
log_table in XML format, but i do need to log a user who did that and
not succsessful with this.
The documentation (including "37.10. Trigger Procedures") give me nothing.
Could somene supply me
Dear All,
I have made a trigger procedure that logs all table's changes to the
log_table in XML format, but i do need to log a user who did that and
not succsessful with this.
The documentation (including "37.10. Trigger Procedures") give me nothing.
Could somene supply me with a solution or docu
