You can usually get the directory name by doing
SELECT dataname, oid FROM pg_databases;
To get the file name do:
SELECT relname, relfilenode FROM pg_class WHERE relname = 'tblName';
The relfilenode will tell you what numbed file belongs to the talbe. It's not always OID, but it often is (don't just assume it will be the OID).
J.
--
........................................
.... Jason C. Leach
.... PGP Key: 0x62DDDF75
.... Keyserver:
gpg.mit.edu
