Viewing Parse Tree of a query from front end

From: Jonathan Gardner <jgardner(at)jonathangardner(dot)net>
To: PostgreSQL Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: Viewing Parse Tree of a query from front end
Date: 2003-11-27 08:18:33
Message-ID: 200311270018.34721.jgardner@jonathangardner.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I know this sounds kind of silly, but I think I would like to be able to
send a query to PostgreSQL, and have it parse it into a tree, and then pass
the tree back to me somehow. Of course, I don't want the query to actually
execute.

Writing the front end application of materialized views, I would like to see
if I can deduce what triggers to put where based on the parse tree a query
returns.

Are there any tools to do this? Is this something that exists but is not
documented? Perhaps we can add a "PARSE TREE <query>" command?

- --
Jonathan Gardner
jgardner(at)jonathangardner(dot)net
Live Free, Use Linux!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE/xbNZWgwF3QvpWNwRAmFuAKDVLnj4/66MFHya7bGGeVTs5os0UwCeIcB7
HYzvgpkc8FCyWRAyh75mn3k=
=TVIM
-----END PGP SIGNATURE-----

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Nhan NGO DINH 2003-11-27 08:49:22 timestamp convert function
Previous Message Shridhar Daithankar 2003-11-27 06:50:57 Re: 7.5 Plans