From 47671aae774f067a173f99ef096d66991ebfd340 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 20 May 2010 03:45:38 +0000 Subject: [PATCH] Show oid2name command-line arguments in documentation like we do for non-contrib command-line tools (no longer in a single table display). --- doc/src/sgml/oid2name.sgml | 197 ++++++++++++++++++------------------- 1 file changed, 97 insertions(+), 100 deletions(-) diff --git a/doc/src/sgml/oid2name.sgml b/doc/src/sgml/oid2name.sgml index 57893a3d12..1c12789352 100644 --- a/doc/src/sgml/oid2name.sgml +++ b/doc/src/sgml/oid2name.sgml @@ -1,4 +1,4 @@ - + oid2name @@ -30,119 +30,116 @@ oid2name connects to a target database and extracts OID, filenode, and/or table name information. You can also have - it show database OIDs or tablespace OIDs. The program is controlled by - a large number of command-line options, as shown in - . + it show database OIDs or tablespace OIDs. - - <application>oid2name</> options - - - - Option - Description - - - - - - -o oid - show info for table with OID oid - - - - -f filenode - show info for table with filenode filenode - - - - -t tablename_pattern - show info for table(s) matching tablename_pattern - - - - -s - show tablespace OIDs - - - - -S - include system objects (those in - information_schema, pg_toast - and pg_catalog schemas) - - - - - -i - include indexes and sequences in the listing - - - - -x - display more information about each object shown: tablespace name, - schema name, and OID - - - - - -q - omit headers (useful for scripting) - - - - -d database - database to connect to - - - - -H host - database server's host - - - - -p port - database server's port - - - - -U username - username to connect as - - - - -P password - password (deprecated — putting this on the command line - is a security hazard) - - - -
+ + + + <application>oid2name</> options + + + oid2name accepts the following command-line arguments: + + + + + oid + show info for table with OID oid + + + + filenode + show info for table with filenode filenode + + + + tablename_pattern + show info for table(s) matching tablename_pattern + + + + + show tablespace OIDs + + + + + include system objects (those in + , + and schemas) + + + + + + include indexes and sequences in the listing + + + + + display more information about each object shown: tablespace name, + schema name, and OID + + + + + + omit headers (useful for scripting) + + + + database + database to connect to + + + + host + database server's host + + + + port + database server's port + + + + username + username to connect as + + + + password + password (deprecated — putting this on the command line + is a security hazard) + + + + To display specific tables, select which tables to show by - using -o, -f and/or -t. - -o takes an OID, - -f takes a filenode, - and -t takes a tablename (actually, it's a LIKE - pattern, so you can use things like foo%). + using - If you don't give any of -o, -f or -t, - but do give -d, it will list all tables in the database - named by -d. In this mode, the -S and - -i options control what gets listed. + If you don't give any of - If you don't give -d either, it will show a listing of database - OIDs. Alternatively you can give -s to get a tablespace + If you don't give -- 2.40.0