Re: Numeric file names - Mailing list pgsql-hackers

From Vadim Mikheev
Subject Re: Numeric file names
Date
Msg-id 006001c04130$93d4b400$b97a30d0@sectorbase.com
Whole thread Raw
In response to Re: Numeric file names  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
> > Now that we have numeric file names, I would like to have a command I
> > can run from psql that will dump a mapping of numeric file name to table
> > name, i.e.,
> >
> > 121233 pg_proc
> > 143423 pg_index
>
> select oid, relname from pg_class;

No. select relfilenode, relname from pg_class - in theory relfilenode may
differ
from relation oid.

Vadim




pgsql-hackers by date:

Previous
From: "Vadim Mikheev"
Date:
Subject: Re: Proposal for DROP TABLE rollback mechanism
Next
From: Tatsuo Ishii
Date:
Subject: Re: more multibyte/After TGL...