Results 1 to 2 of 2

Thread: about trigger

  1. #1
    Join Date
    Apr 2004
    Posts
    1

    Lightbulb Unanswered: about trigger

    How can u get, extract column name(from trigger), that caused the trigger invocation. TG_RELNAME i can get table name, but I need column name. Is it possible?

    Thanks

  2. #2
    Join Date
    Mar 2004
    Posts
    110
    I think i've read you can invoke triggers not only on tablenames but on column names too (correct me if im wrong).

    Guess that would be a whole lotta code tho to create a trigger per column.

    Isnt it easier to do a before trigger on the whole table and then compare the old values against the new ones?

    I must admit, i'm still exploring postgresql and its full potential.

    -Ed
    Another noobie user

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •