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 valu

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 everyt

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 th

[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 page.