oid2name列出PostgreSQL和对应的oid

1 2 3 4 5 6 7 8 9 10

Name  oid2name -- resolve OIDs and file nodes in a PostgreSQL data directory   Synopsis  oid2name [option...]   Description  oid2name is a utility program that helps administrators to examine the file structure used by  PostgreSQL. To make use of it, you need to be familiar with the database file structure, which  is described in Chapter 56.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

[pg12@db12 pg_tblspc]$ oid2name --help oid2name helps examining the file structure used by PostgreSQL.   Usage:  oid2name [OPTION]...   Options:  -d DBNAME   database to connect to  -f FILENODE  show info for table with given file node  -H HOSTNAME  database server host or socket directory  -i       show indexes and sequences too  -o OID     show info for table with given OID  -p PORT    database server port number  -q       quiet (dont show headers)  -s       show all tablespaces  -S       show system objects too  -t TABLE    show info for named table  -U NAME    connect as specified database user  -V, --version output version information, then exit  -x       extended (show additional columns)  -?, --help   show this help, then exit   The default action is to show all database OIDs.   Report bugs to <pgsql-bugs@postgresql.org>.

1 2 3 4 5 6 7 8 9

[pg12@db12 pg_tblspc]$ oid2name All databases:   Oid Database Name   Tablespace -------------------------------------  16386 francs   tbs_francs  12895    postgres   pg_default  16390   source_db tbs_source_db  12890   template0   pg_default    1   template1   pg_default

1 2 3 4 5 6 7 8

[pg12@db12 pg_tblspc]$ oid2name -s All tablespaces:   Oid Tablespace Name ------------------------  1663    pg_default  1664    pg_global  16385 tbs_francs  16389  tbs_source_db

1 2 3 4 5 6 7 8 9 10 11 12

[pg12@db12 16386]$ cd $PGDATA/pg_tblspc/16385 [pg12@db12 16385]$ cd PG_9.3_201305061/16386/   [pg12@db12 16386]$ ll | tail -n 8 -rw-------. 1 pg12 pg12 35M Jun 3 17:47 16702 -rw-------. 1 pg12 pg12 161M Jun 3 16:22 16703 -rw-------. 1 pg12 pg12 64K Jun 3 15:45 16703_fsm -rw-------. 1 pg12 pg12 8.0K Jun 3 16:14 16703_vm -rw-------. 1 pg12 pg12 35M Jun 3 15:45 16704 -rw-------. 1 pg12 pg12 512 May 15 10:30 pg_filenode.map -rw-------. 1 pg12 pg12 98K Jun 3 10:26 pg_internal.init -rw-------. 1 pg12 pg12  4 May 15 10:30 PG_VERSION

1 2 3 4 5

[pg12@db12 16386]$ oid2name -d francs -f 16703 From database "francs":  Filenode   Table Name -------------------------   16703 test_not_full

1 2 3 4 5

[pg12@db12 16386]$ oid2name -d francs -f 16703 -x From database "francs":  Filenode   Table Name  Oid Schema Tablespace ----------------------------------------------------   16703 test_not_full 16688 francs tbs_francs

1 2 3 4 5 6 7 8 9 10 11

[pg12@db12 ~]$ psql francs francs -c "select oid,relname from pg_class where relname='test_1'";  oid | relname ------- --------- 16457 | test_1 (1 row)   [pg12@db12 ~]$ oid2name -d francs -o 16457 From database "francs":  Filenode Table Name ----------------------   16457   test_1