Sure, see the debug_ variables in postgresql.conf or via SHOW ALL, and then set client_log_messages to DEBUG. Also look at debug_pretty_print.
--------------------------------------------------------------------------- Eric D Nielsen wrote: > I've gotten back to working on the SQL99 version of updateable views and > I'ld like to confirm my current understanding of the parse tree data > structure. Is there a debugging-type tool for outputting the parse tree for > a given query? > > Eric Nielsen > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
