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

From: David Kerr <dmk(at)mr-paradox(dot)net>
To: Soroosh Sardari <soroosh(dot)sardari(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Which table stored in which file in PGDATA/base/[db-oid]
Date: 2013-06-04 20:15:48
Message-ID: 20130604201548.GC96228@mr-paradox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

- On Sat, Jun 1, 2013 at 3:57 PM, Andres Freund <andres(at)2ndquadrant(dot)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>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2013-06-04 20:20:11 Re: Configurable location for extension .control files
Previous Message Tom Lane 2013-06-04 20:14:22 Re: Improved error message for CREATE EXTENSION patch...