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 ---------------------------(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