How to get the DML Commands exceuted from functions

From: "Anoo Pillai" <anoo(dot)postgresql(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: How to get the DML Commands exceuted from functions
Date: 2007-03-23 05:14:49
Message-ID: 75ff88c60703222214v30bc2deble8b588b29f6a3fad@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Hi All,

There are a few plpgsql functions in our application, When the functions are
called, I would like to see the commands executed from the functions ( the
selects, inserts, updates and Deletes written in the function body)

I am from SQL server world and there exists a tool SQL Profiler for the same
purpose. I am looking for something like that

Thanks in advance

Anoo.S

Browse pgsql-admin by date

  From Date Subject
Next Message Karthikeyan Sundaram 2007-03-23 05:47:13 Re: How to get the DML Commands exceuted from functions
Previous Message Chris Browne 2007-03-22 19:06:04 Re: slony with diff PostgreSQL versions

Browse pgsql-general by date

  From Date Subject
Next Message Karthikeyan Sundaram 2007-03-23 05:47:13 Re: How to get the DML Commands exceuted from functions
Previous Message Tom Lane 2007-03-23 03:32:53 Re: VACUUM ANALYZE