Thread: oid2name

Patchers,

Here is a patch bringing oid2name into the 21st century.  Supports
schemas (thought you can't select what schema to display), tablespaces,
and using -o for OIDs and -f for filenames (pg_class.relfilenode).  Also
-t now accepts LIKE patterns.  There can be multiple and mixed -o, -f
and -t arguments, and it will show all the objects in one go.

By default it only shows filenode and relation name, though a -x switch
makes it include tablespace name, schema name and OID.

Also, the headers are prettier.

Please comment, review and/or apply.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Cuando no hay humildad las personas se degradan" (A. Christie)

Your patch has been added to the PostgreSQL unapplied patches list at:

    http://momjian.postgresql.org/cgi-bin/pgpatches

It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.

---------------------------------------------------------------------------


Alvaro Herrera wrote:
> Patchers,
>
> Here is a patch bringing oid2name into the 21st century.  Supports
> schemas (thought you can't select what schema to display), tablespaces,
> and using -o for OIDs and -f for filenames (pg_class.relfilenode).  Also
> -t now accepts LIKE patterns.  There can be multiple and mixed -o, -f
> and -t arguments, and it will show all the objects in one go.
>
> By default it only shows filenode and relation name, though a -x switch
> makes it include tablespace name, schema name and OID.
>
> Also, the headers are prettier.
>
> Please comment, review and/or apply.
>
> --
> Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
> "Cuando no hay humildad las personas se degradan" (A. Christie)

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
> Here is a patch bringing oid2name into the 21st century.

Applied.  I did some additional editorial hacking on the README file to
try to clarify the explanation of disk layout.  (I suppose what we
really ought to do is migrate that information into the Admin Guide
someplace.)

            regards, tom lane