Re: Which table stored in which file in PGDATA/base/[db-oid]

- On Sat, Jun 1, 2013 at 3:57 PM, Andres Freund <andres@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>