Debugging tool for viewing parse trees?

Eric D Nielsen <nielsene@MIT.EDU> writes:

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?

See debug_print_parse, debug_print_rewritten, debug_print_plan,
debug_pretty_print GUC variables.

regards, tom lane

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
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073