[GENERAL] sniffing postgres queries

2007-03-20 Thread Anton Melser
Hi, I am having real trouble with a project that is a little out of my league and I just can't find out how to find which table the app is getting its values from (it's a long story...). I know what values I am looking for, and would like to log everything (even if only for one call of a web

Re: [GENERAL] sniffing postgres queries

2007-03-20 Thread John DeSoi
You might be able to get enough information looking at the raw frontend/backend protocol exchange (http://www.postgresql.org/docs/ 8.2/static/protocol.html) using something like tcpflow or Ethereal. On Mar 20, 2007, at 5:45 PM, Anton Melser wrote: I am having real trouble with a project

Re: [GENERAL] sniffing postgres queries

2007-03-20 Thread Tom Lane
Anton Melser [EMAIL PROTECTED] writes: I am having real trouble with a project that is a little out of my league and I just can't find out how to find which table the app is getting its values from (it's a long story...). I know what values I am looking for, and would like to log everything

Re: [GENERAL] sniffing postgres queries

2007-03-20 Thread Anton Melser
On 21/03/07, Tom Lane [EMAIL PROTECTED] wrote: Anton Melser [EMAIL PROTECTED] writes: I am having real trouble with a project that is a little out of my league and I just can't find out how to find which table the app is getting its values from (it's a long story...). I know what values I am