"Cristiano Duarte" <[EMAIL PROTECTED]> wrote > Does anyone know how to discover the tables (with schemas or oid) > involved > on a select statement? > I tried EXPLAIN but it only reports the table names, not schemas or > oid. >
In general, this is a pretty difficult problem - thinking you may do a selection on a function which involves some other tables. By EXPLAIN, you can only see a function scan node. Regards, Qingqing ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
