- On Sat, Jun 1, 2013 at 3:57 PM, Andres Freund <and...@2ndquadrant.com>wrote: - - > On 2013-06-01 13:04:55 +0200, Martijn van Oosterhout wrote: - > To get the actual relfilenode you actually need to do something like: - > SELECT relname, pg_relation_filenode(pg_class.oid) FROM pg_class; - - Dear Andres - - You are right, Some tables are mapped, and some other are global. - The SQL query is really helpful.
Another option, is to use oid2name http://www.postgresql.org/docs/devel/static/oid2name.html oid2name -S -d <database> -f <filename> -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers