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.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
