Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Postgres triggers: planting external arguments?

Status
Not open for further replies.
YonmaN

YonmaN

Programmer
Jun 4, 2002
12
IL
Heya guys

I am now attempting to create a logging trigger that will be performed on every insertion to it's tracked table.

However, I'd also like to track the user's IP address and his userid. This would mean to me, that I have to "plant" external arguments, besides the "NEW" element, that holds these two parameters for my use.

Is this possible?
could you give me an example in pl/pgSql?

tnx :)
 
Status
Not open for further replies.

Similar threads

wbower34
  • Locked
  • Question
Postgres 9.6 Books
Replies
0
Views
127
wbower34
wbower34
OJSan
  • Locked
  • Question
On Postgresql 10 i can replace or rename the default Postgresql account?
Replies
0
Views
136
OJSan
OJSan
LD50
  • Locked
  • Question
postgres 9.0 streaming replication for reporting
Replies
0
Views
109
LD50
LD50
dbrb2
  • Locked
  • Question
Postgresql cursor loop
Replies
1
Views
130
feherke
feherke
JowiTss
  • Locked
  • Question
Postgres with C#
Replies
0
Views
63
JowiTss
JowiTss

Part and Inventory Search

Sponsor

Back
Top