From 0fa2afa93a75ee03960b9d5e2fcbd67ed6f9e8c6 Mon Sep 17 00:00:00 2001 From: Neil Conway Date: Thu, 22 Apr 2004 17:38:16 +0000 Subject: Make psql's \d+ command indicate whether the table in question contains OIDs. Also, minor documentation improvements to the psql reference page. --- doc/src/sgml/perform.sgml | 5 +- doc/src/sgml/ref/psql-ref.sgml | 122 +++++++++++++++++++++++------------------ 2 files changed, 71 insertions(+), 56 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/perform.sgml b/doc/src/sgml/perform.sgml index e9a34ecad2b..d49c57793b7 100644 --- a/doc/src/sgml/perform.sgml +++ b/doc/src/sgml/perform.sgml @@ -1,5 +1,5 @@ @@ -633,8 +633,9 @@ SELECT * FROM x, y, a, b, c WHERE something AND somethingelse; Disable Autocommit - + autocommit + bulk-loading data diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index 6ae2ba854e5..dee5a60e68c 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -1,5 +1,5 @@ @@ -638,7 +638,7 @@ testdb=> - \cd directory + \cd [ directory ] Changes the current working directory to @@ -655,7 +655,7 @@ testdb=> - \C [ title ] + \C [ title ] Sets the title of any tables being printed as the result of a @@ -670,7 +670,7 @@ testdb=> - \connect (or \c) [ dbname [ username ] ] + \connect (or \c) [ dbname [ username ] ] Establishes a connection to a new database and/or under a user @@ -708,14 +708,14 @@ testdb=> [ ( column_list ) ] { from | to } { filename | stdin | stdout | pstdin | pstdout } - [ with ] - [ oids ] - [ delimiter [as] 'character' ] - [ null [as] 'string' ] - [ csv [ quote [as] 'character' ] - [ escape [as] 'character' ] - [ force quote column_list ] - [ force not null column_list ] ] + [ with ] + [ oids ] + [ delimiter [ as ] 'character' ] + [ null [ as ] 'string' ] + [ csv [ quote [ as ] 'character' ] + [ escape [ as ] 'character' ] + [ force quote column_list ] + [ force not null column_list ] ] @@ -777,7 +777,8 @@ testdb=> - \d [ pattern ] + \d [ pattern ] + \d+ [ pattern ] @@ -791,8 +792,10 @@ testdb=> - The command form \d+ is identical, but any - comments associated with the table columns are shown as well. + The command form \d+ is identical, except that + more information is displayed: any comments associated with the + columns of the table are shown, as is the presence of OIDs in the + table. @@ -808,7 +811,7 @@ testdb=> - \da [ pattern ] + \da [ pattern ] @@ -822,7 +825,7 @@ testdb=> - \dc [ pattern ] + \dc [ pattern ] Lists all available conversions between character-set encodings. @@ -845,7 +848,7 @@ testdb=> - \dd [ pattern ] + \dd [ pattern ] Shows the descriptions of objects matching the - Descriptions for objects can be created with the - COMMENT SQL command. - + Descriptions for objects can be created with the + SQL command. + - \dD [ pattern ] + \dD [ pattern ] Lists all available domains. If \df [ pattern ] + \df+ [ pattern ] @@ -920,8 +925,9 @@ testdb=> \dg [ pattern ] - Lists all database groups or only those that match pattern. + Lists all database groups. If pattern is specified, only + those groups whose names match the pattern are listed. @@ -932,14 +938,16 @@ testdb=> - This is not the actual command name: the letters i, s, t, v, S - stand for index, sequence, table, view, and system table, - respectively. You can specify any or all of these letters, in any - order, to obtain a listing of all the matching objects. The letter - S restricts the listing to system objects; without S, only non-system - objects are shown. - If + is appended to the command name, each object is - listed with its associated description, if any. + This is not the actual command name: the letters + i, s, t, + v, S stand for index, + sequence, table, view, and system table, respectively. You can + specify any or all of these letters, in any order, to obtain a + listing of all the matching objects. The letter S restricts the + listing to system objects; without S, only + non-system objects are shown. If + is appended + to the command name, each object is listed with its associated + description, if any. @@ -962,7 +970,7 @@ testdb=> - \dn [ pattern ] + \dn [ pattern ] @@ -988,7 +996,7 @@ testdb=> - \dp [ pattern ] + \dp [ pattern ] Produces a list of all available tables, views and sequences with their @@ -1009,6 +1017,7 @@ testdb=> \dT [ pattern ] + \dT+ [ pattern ] Lists all data types or only those that match - \edit (or \e) [ filename ] + \edit (or \e) [ filename ] @@ -1065,7 +1074,7 @@ testdb=> - \echo text [ ... ] + \echo text [ ... ] Prints the arguments to the standard output, separated by one @@ -1091,7 +1100,7 @@ Tue Oct 26 21:40:57 CEST 1999 - \encoding [ encoding ] + \encoding [ encoding ] @@ -1103,7 +1112,7 @@ Tue Oct 26 21:40:57 CEST 1999 - \f [ string ] + \f [ string ] @@ -1134,7 +1143,7 @@ Tue Oct 26 21:40:57 CEST 1999 - \help (or \h) [ command ] + \help (or \h) [ command ] Gives syntax help on the specified SQL @@ -1172,7 +1181,7 @@ Tue Oct 26 21:40:57 CEST 1999 - \i filename + \i filename Reads input from the file \l (or \list) + \l+ (or \list+) List the names, owners, and character set encodings of all the databases in - the server. Append a + to the command name to - see any descriptions for the databases as well. + the server. If + is appended to the command + name, database descriptions are also displayed. - \lo_export loid filename + \lo_export loid filename @@ -1227,7 +1237,7 @@ Tue Oct 26 21:40:57 CEST 1999 - \lo_import filename [ comment ] + \lo_import filename [ comment ] @@ -1266,7 +1276,7 @@ lo_import 152801 - \lo_unlink loid + \lo_unlink loid @@ -1326,7 +1336,7 @@ lo_import 152801 - \pset parameter [ value ] + \pset parameter [ value ] @@ -1459,7 +1469,7 @@ lo_import 152801 - title [ text ] + title [ text ] Sets the table title for any subsequently printed tables. This @@ -1470,7 +1480,7 @@ lo_import 152801 - tableattr (or T) [ text ] + tableattr (or T) [ text ] Allows you to specify any attributes to be placed inside the @@ -1546,7 +1556,7 @@ lo_import 152801 - \qecho text [ ... ] + \qecho text [ ... ] This command is identical to \echo except @@ -1568,7 +1578,7 @@ lo_import 152801 - \s [ filename ] + \s [ filename ] Print or save the command line history to - \set [ name [ value [ ... ]]] + \set [ name [ value [ ... ] ] ] @@ -1641,7 +1651,7 @@ lo_import 152801 - \T table_options + \T table_options Allows you to specify attributes to be placed within the @@ -1688,7 +1698,7 @@ lo_import 152801 - \z [ pattern ] + \z [ pattern ] Produces a list of all available tables, views and sequences with their @@ -1713,7 +1723,7 @@ lo_import 152801 - \! [ command ] + \! [ command ] Escapes to a separate Unix shell or executes the Unix command @@ -1832,6 +1842,10 @@ bar + + autocommit + psql + AUTOCOMMIT -- cgit v1.2.3