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.
I am developing a SNAPSHOT project for PostgreSQL called Pg::snapshots. It
can be found here:
http://cunha17.theicy.net/personal/postgresql/snapshots.en_us.php
Everything is working, except that at some point I need to figure out wich
tables are data sources on a query in order to test for snapshot logs for
fast refresh. Since I can't get the place (schema) where the table is, I
can't test for the snapshot log table (wich is placed on the same schema as
the master table).
Any help would be greatly appreciated.
Regards,
Cristiano Duarte