Re: Log query results?

Robert Creager <Robert_Creager@LogicalChaos.org> writes:
> I'm running 7.4.1 and am having problem when my app starts loading up on the
> database.  I want to verify the data coming back from the queries is correct
> from the server side (not application side), as then I'll be sure my app is
> squirrelly (or the db is).

> I don't see any options in postgresql.conf that would allow this, but was
> wondering if any of the debug levels might get me what I want.  Or is there a
> better way?

Nothing on the backend side that I can think of.  If you're using libpq
then you could use PQtrace, though that's really intended for debugging
libpq itself.  Or you could point a packet sniffer at the TCP
connection.

            regards, tom lane