On 06.02.2007 15:00, Richard Huxton wrote:
Hannes Dorbath wrote:
On 06.02.2007 14:19, Richard Huxton wrote:
What is best way to retrieve all affected tables of an select
statement? (Besides parsing the raw SQL).
From where? As a client-application function? As a user-callable
function in the server? From within the parse/execute code?
From a client application.
Parsing the sql is the only way I can think of.
You could feed it through EXPLAIN I suppose, but there's no way to dump
the query-plan as a data-structure to the client. You can log a verbose
query-plan, but that's not going to help you.
EXPLAIN VERBOSE gives me :resorigtbl. I think that is what I was after.
--
Regards,
Hannes Dorbath
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match