Is there a way to view a rewritten query? - Mailing list pgsql-general

From Jonathan Knopp
Subject Is there a way to view a rewritten query?
Date
Msg-id 41AFFA73.7090600@delegated.net
Whole thread Raw
Responses Re: Is there a way to view a rewritten query?  (Chris Green <chris@areti.co.uk>)
Re: Is there a way to view a rewritten query?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I'm trying to set up some complex rules and having a hard time figuring
out why they won't work. Being able to see the query after all the rules
have been applied would be a huge help, but I can't seem to find a way
to do this. log_statement only shows the original. debug_print_rewritten
works, but displays it in such a way as to be virtually unusable.
someone please tell me there's a simple way of doing this cause i'm
ready to take a hammer to my computer.

thanks



pgsql-general by date:

Previous
From: "ON.KG"
Date:
Subject: Re: Select Database
Next
From: OpenMacNews
Date:
Subject: Re: [SOLVED] Re: pgsql8b5 not launching on OSX system start