"Cristiano Duarte" <cunha17(at)gmail(dot)com> 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