On 24 June 2011 23:21, Tom Lane <t...@sss.pgh.pa.us> wrote: > Shigeru Hanada <shigeru.han...@gmail.com> writes: > > (2011/06/24 15:35), HuangQi wrote: > >> I'm trying to debug a modification for the query planner. But I found it > >> seems the data structure of my planned query is incorrect. I was trying > to > >> print out the data structure by use the "p" command in gdb which is > quite > >> inconvenient and takes time. May I know is there any embedded function > in > >> postgres to print out the node data structures, or any other plan > related > >> data structures? Thanks. > > > I think nodeToString() would help. > > For interactive use in gdb, I generally do > > call pprint(..node pointer..) > > which prints to the postmaster log. > > regards, tom lane >
Thanks, Tom, this call pprint() works very nice. -- Best Regards Huang Qi Victor