About debugging trigger

Hi,

I have a question about how to insert standard output statement in trigger for debugging purpose.

I have tried using the following:

• echo 'show debug message' ;
• echo "show debug message" ;
• print("show debug message");
• print('show debug message');
• dbms_output.put_line('show debug message');
• dbms_output.put_line("show debug message");

However, I got the following error message:

• ERROR:  syntax error at or near "echo" at character 1
  QUERY:  echo 'show debug message'
• ERROR:  syntax error at or near "print" at character 1
  QUERY:  print('show debug message')
• ERROR:  syntax error at or near "dbms_output" at character 1
  QUERY:  dbms_output.put_line("show debug message")

I know that in Oracle, the way to insert standard output statement in trigger is using dbms_output.put_line() method, but it doesn't seem to work in pgadmin.

I have already checked the frequently asked questions list as well as the pgAdmin documentation for a solution and I also have tried searching Google, however I can not find a solution for it. Please help when you get a chance!

Thank you in advance,

Michael