From bb4eefe7bf518e42c73797ea37b033a5d8a8e70a Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Sun, 23 Feb 2014 21:25:35 -0500 Subject: [PATCH] doc: Improve DocBook XML validity DocBook XML is superficially compatible with DocBook SGML but has a slightly stricter DTD that we have been violating in a few cases. Although XSLT doesn't care whether the document is valid, the style sheets don't necessarily process invalid documents correctly, so we need to work toward fixing this. This first commit moves the indexterms in refentry elements to an allowed position. It has no impact on the output. --- doc/src/sgml/dblink.sgml | 152 +++++++-------- doc/src/sgml/oid2name.sgml | 8 +- doc/src/sgml/pg_xlogdump.sgml | 8 +- doc/src/sgml/pgarchivecleanup.sgml | 8 +- doc/src/sgml/pgbench.sgml | 8 +- doc/src/sgml/pgstandby.sgml | 8 +- doc/src/sgml/pgtestfsync.sgml | 8 +- doc/src/sgml/pgtesttiming.sgml | 8 +- doc/src/sgml/pgupgrade.sgml | 8 +- doc/src/sgml/ref/abort.sgml | 8 +- doc/src/sgml/ref/alter_aggregate.sgml | 8 +- doc/src/sgml/ref/alter_collation.sgml | 8 +- doc/src/sgml/ref/alter_conversion.sgml | 8 +- doc/src/sgml/ref/alter_database.sgml | 8 +- .../sgml/ref/alter_default_privileges.sgml | 8 +- doc/src/sgml/ref/alter_domain.sgml | 8 +- doc/src/sgml/ref/alter_event_trigger.sgml | 8 +- doc/src/sgml/ref/alter_extension.sgml | 8 +- .../sgml/ref/alter_foreign_data_wrapper.sgml | 8 +- doc/src/sgml/ref/alter_foreign_table.sgml | 8 +- doc/src/sgml/ref/alter_function.sgml | 8 +- doc/src/sgml/ref/alter_group.sgml | 8 +- doc/src/sgml/ref/alter_index.sgml | 8 +- doc/src/sgml/ref/alter_language.sgml | 8 +- doc/src/sgml/ref/alter_large_object.sgml | 8 +- doc/src/sgml/ref/alter_materialized_view.sgml | 8 +- doc/src/sgml/ref/alter_opclass.sgml | 8 +- doc/src/sgml/ref/alter_operator.sgml | 8 +- doc/src/sgml/ref/alter_opfamily.sgml | 8 +- doc/src/sgml/ref/alter_role.sgml | 8 +- doc/src/sgml/ref/alter_rule.sgml | 8 +- doc/src/sgml/ref/alter_schema.sgml | 8 +- doc/src/sgml/ref/alter_sequence.sgml | 8 +- doc/src/sgml/ref/alter_server.sgml | 8 +- doc/src/sgml/ref/alter_system.sgml | 8 +- doc/src/sgml/ref/alter_table.sgml | 8 +- doc/src/sgml/ref/alter_tablespace.sgml | 8 +- doc/src/sgml/ref/alter_trigger.sgml | 8 +- doc/src/sgml/ref/alter_tsconfig.sgml | 8 +- doc/src/sgml/ref/alter_tsdictionary.sgml | 8 +- doc/src/sgml/ref/alter_tsparser.sgml | 8 +- doc/src/sgml/ref/alter_tstemplate.sgml | 8 +- doc/src/sgml/ref/alter_type.sgml | 8 +- doc/src/sgml/ref/alter_user.sgml | 8 +- doc/src/sgml/ref/alter_user_mapping.sgml | 8 +- doc/src/sgml/ref/alter_view.sgml | 8 +- doc/src/sgml/ref/analyze.sgml | 8 +- doc/src/sgml/ref/begin.sgml | 8 +- doc/src/sgml/ref/checkpoint.sgml | 8 +- doc/src/sgml/ref/close.sgml | 18 +- doc/src/sgml/ref/cluster.sgml | 8 +- doc/src/sgml/ref/clusterdb.sgml | 8 +- doc/src/sgml/ref/comment.sgml | 8 +- doc/src/sgml/ref/commit.sgml | 8 +- doc/src/sgml/ref/commit_prepared.sgml | 8 +- doc/src/sgml/ref/copy.sgml | 8 +- doc/src/sgml/ref/create_aggregate.sgml | 8 +- doc/src/sgml/ref/create_cast.sgml | 8 +- doc/src/sgml/ref/create_collation.sgml | 8 +- doc/src/sgml/ref/create_conversion.sgml | 8 +- doc/src/sgml/ref/create_database.sgml | 8 +- doc/src/sgml/ref/create_domain.sgml | 8 +- doc/src/sgml/ref/create_event_trigger.sgml | 8 +- doc/src/sgml/ref/create_extension.sgml | 8 +- .../sgml/ref/create_foreign_data_wrapper.sgml | 8 +- doc/src/sgml/ref/create_foreign_table.sgml | 8 +- doc/src/sgml/ref/create_function.sgml | 8 +- doc/src/sgml/ref/create_group.sgml | 8 +- doc/src/sgml/ref/create_index.sgml | 8 +- doc/src/sgml/ref/create_language.sgml | 8 +- .../sgml/ref/create_materialized_view.sgml | 8 +- doc/src/sgml/ref/create_opclass.sgml | 8 +- doc/src/sgml/ref/create_operator.sgml | 8 +- doc/src/sgml/ref/create_opfamily.sgml | 8 +- doc/src/sgml/ref/create_role.sgml | 8 +- doc/src/sgml/ref/create_rule.sgml | 8 +- doc/src/sgml/ref/create_schema.sgml | 8 +- doc/src/sgml/ref/create_sequence.sgml | 8 +- doc/src/sgml/ref/create_server.sgml | 8 +- doc/src/sgml/ref/create_table.sgml | 8 +- doc/src/sgml/ref/create_table_as.sgml | 8 +- doc/src/sgml/ref/create_tablespace.sgml | 8 +- doc/src/sgml/ref/create_trigger.sgml | 8 +- doc/src/sgml/ref/create_tsconfig.sgml | 8 +- doc/src/sgml/ref/create_tsdictionary.sgml | 8 +- doc/src/sgml/ref/create_tsparser.sgml | 8 +- doc/src/sgml/ref/create_tstemplate.sgml | 8 +- doc/src/sgml/ref/create_type.sgml | 8 +- doc/src/sgml/ref/create_user.sgml | 8 +- doc/src/sgml/ref/create_user_mapping.sgml | 8 +- doc/src/sgml/ref/create_view.sgml | 8 +- doc/src/sgml/ref/createdb.sgml | 8 +- doc/src/sgml/ref/createlang.sgml | 8 +- doc/src/sgml/ref/createuser.sgml | 8 +- doc/src/sgml/ref/deallocate.sgml | 18 +- doc/src/sgml/ref/declare.sgml | 18 +- doc/src/sgml/ref/delete.sgml | 8 +- doc/src/sgml/ref/discard.sgml | 8 +- doc/src/sgml/ref/do.sgml | 16 +- doc/src/sgml/ref/drop_aggregate.sgml | 8 +- doc/src/sgml/ref/drop_cast.sgml | 8 +- doc/src/sgml/ref/drop_collation.sgml | 8 +- doc/src/sgml/ref/drop_conversion.sgml | 8 +- doc/src/sgml/ref/drop_database.sgml | 8 +- doc/src/sgml/ref/drop_domain.sgml | 8 +- doc/src/sgml/ref/drop_event_trigger.sgml | 8 +- doc/src/sgml/ref/drop_extension.sgml | 8 +- .../sgml/ref/drop_foreign_data_wrapper.sgml | 8 +- doc/src/sgml/ref/drop_foreign_table.sgml | 8 +- doc/src/sgml/ref/drop_function.sgml | 8 +- doc/src/sgml/ref/drop_group.sgml | 8 +- doc/src/sgml/ref/drop_index.sgml | 8 +- doc/src/sgml/ref/drop_language.sgml | 8 +- doc/src/sgml/ref/drop_materialized_view.sgml | 8 +- doc/src/sgml/ref/drop_opclass.sgml | 8 +- doc/src/sgml/ref/drop_operator.sgml | 8 +- doc/src/sgml/ref/drop_opfamily.sgml | 8 +- doc/src/sgml/ref/drop_owned.sgml | 8 +- doc/src/sgml/ref/drop_role.sgml | 8 +- doc/src/sgml/ref/drop_rule.sgml | 8 +- doc/src/sgml/ref/drop_schema.sgml | 8 +- doc/src/sgml/ref/drop_sequence.sgml | 8 +- doc/src/sgml/ref/drop_server.sgml | 8 +- doc/src/sgml/ref/drop_table.sgml | 8 +- doc/src/sgml/ref/drop_tablespace.sgml | 8 +- doc/src/sgml/ref/drop_trigger.sgml | 8 +- doc/src/sgml/ref/drop_tsconfig.sgml | 8 +- doc/src/sgml/ref/drop_tsdictionary.sgml | 8 +- doc/src/sgml/ref/drop_tsparser.sgml | 8 +- doc/src/sgml/ref/drop_tstemplate.sgml | 8 +- doc/src/sgml/ref/drop_type.sgml | 8 +- doc/src/sgml/ref/drop_user.sgml | 8 +- doc/src/sgml/ref/drop_user_mapping.sgml | 8 +- doc/src/sgml/ref/drop_view.sgml | 8 +- doc/src/sgml/ref/dropdb.sgml | 8 +- doc/src/sgml/ref/droplang.sgml | 8 +- doc/src/sgml/ref/dropuser.sgml | 8 +- doc/src/sgml/ref/ecpg-ref.sgml | 8 +- doc/src/sgml/ref/end.sgml | 8 +- doc/src/sgml/ref/execute.sgml | 18 +- doc/src/sgml/ref/explain.sgml | 22 +-- doc/src/sgml/ref/fetch.sgml | 18 +- doc/src/sgml/ref/grant.sgml | 8 +- doc/src/sgml/ref/initdb.sgml | 8 +- doc/src/sgml/ref/insert.sgml | 8 +- doc/src/sgml/ref/listen.sgml | 8 +- doc/src/sgml/ref/load.sgml | 8 +- doc/src/sgml/ref/lock.sgml | 8 +- doc/src/sgml/ref/move.sgml | 18 +- doc/src/sgml/ref/notify.sgml | 8 +- doc/src/sgml/ref/pg_basebackup.sgml | 8 +- doc/src/sgml/ref/pg_config-ref.sgml | 8 +- doc/src/sgml/ref/pg_controldata.sgml | 8 +- doc/src/sgml/ref/pg_ctl-ref.sgml | 8 +- doc/src/sgml/ref/pg_dump.sgml | 8 +- doc/src/sgml/ref/pg_dumpall.sgml | 8 +- doc/src/sgml/ref/pg_isready.sgml | 8 +- doc/src/sgml/ref/pg_receivexlog.sgml | 8 +- doc/src/sgml/ref/pg_resetxlog.sgml | 8 +- doc/src/sgml/ref/pg_restore.sgml | 8 +- doc/src/sgml/ref/postgres-ref.sgml | 8 +- doc/src/sgml/ref/postmaster.sgml | 8 +- doc/src/sgml/ref/prepare.sgml | 18 +- doc/src/sgml/ref/prepare_transaction.sgml | 8 +- doc/src/sgml/ref/psql-ref.sgml | 8 +- doc/src/sgml/ref/reassign_owned.sgml | 8 +- .../sgml/ref/refresh_materialized_view.sgml | 8 +- doc/src/sgml/ref/reindex.sgml | 8 +- doc/src/sgml/ref/reindexdb.sgml | 8 +- doc/src/sgml/ref/release_savepoint.sgml | 18 +- doc/src/sgml/ref/reset.sgml | 8 +- doc/src/sgml/ref/revoke.sgml | 8 +- doc/src/sgml/ref/rollback.sgml | 8 +- doc/src/sgml/ref/rollback_prepared.sgml | 8 +- doc/src/sgml/ref/rollback_to.sgml | 18 +- doc/src/sgml/ref/savepoint.sgml | 18 +- doc/src/sgml/ref/security_label.sgml | 8 +- doc/src/sgml/ref/select.sgml | 26 +-- doc/src/sgml/ref/select_into.sgml | 8 +- doc/src/sgml/ref/set.sgml | 8 +- doc/src/sgml/ref/set_constraints.sgml | 8 +- doc/src/sgml/ref/set_role.sgml | 8 +- doc/src/sgml/ref/set_session_auth.sgml | 8 +- doc/src/sgml/ref/set_transaction.sgml | 22 +-- doc/src/sgml/ref/show.sgml | 8 +- doc/src/sgml/ref/start_transaction.sgml | 8 +- doc/src/sgml/ref/truncate.sgml | 8 +- doc/src/sgml/ref/unlisten.sgml | 8 +- doc/src/sgml/ref/update.sgml | 8 +- doc/src/sgml/ref/vacuum.sgml | 8 +- doc/src/sgml/ref/vacuumdb.sgml | 8 +- doc/src/sgml/ref/values.sgml | 8 +- doc/src/sgml/spi.sgml | 176 +++++++++--------- doc/src/sgml/vacuumlo.sgml | 8 +- 194 files changed, 1009 insertions(+), 1009 deletions(-) diff --git a/doc/src/sgml/dblink.sgml b/doc/src/sgml/dblink.sgml index a26e378678..b07ac48c00 100644 --- a/doc/src/sgml/dblink.sgml +++ b/doc/src/sgml/dblink.sgml @@ -19,6 +19,10 @@ + + dblink_connect + + dblink_connect 3 @@ -29,10 +33,6 @@ opens a persistent connection to a remote database - - dblink_connect - - dblink_connect(text connstr) returns text @@ -183,6 +183,10 @@ DROP SERVER fdtest; + + dblink_connect_u + + dblink_connect_u 3 @@ -193,10 +197,6 @@ DROP SERVER fdtest; opens a persistent connection to a remote database, insecurely - - dblink_connect_u - - dblink_connect_u(text connstr) returns text @@ -240,6 +240,10 @@ dblink_connect_u(text connname, text connstr) returns text + + dblink_disconnect + + dblink_disconnect 3 @@ -250,10 +254,6 @@ dblink_connect_u(text connname, text connstr) returns text closes a persistent connection to a remote database - - dblink_disconnect - - dblink_disconnect() returns text @@ -315,6 +315,10 @@ SELECT dblink_disconnect('myconn'); + + dblink + + dblink 3 @@ -325,10 +329,6 @@ SELECT dblink_disconnect('myconn'); executes a query in a remote database - - dblink - - dblink(text connname, text sql [, bool fail_on_error]) returns setof record @@ -533,6 +533,10 @@ SELECT * FROM dblink('myconn', 'select proname, prosrc from pg_proc') + + dblink_exec + + dblink_exec 3 @@ -543,10 +547,6 @@ SELECT * FROM dblink('myconn', 'select proname, prosrc from pg_proc') executes a command in a remote database - - dblink_exec - - dblink_exec(text connname, text sql [, bool fail_on_error]) returns text @@ -670,6 +670,10 @@ DETAIL: ERROR: null value in column "relnamespace" violates not-null constrain + + dblink_open + + dblink_open 3 @@ -680,10 +684,6 @@ DETAIL: ERROR: null value in column "relnamespace" violates not-null constrain opens a cursor in a remote database - - dblink_open - - dblink_open(text cursorname, text sql [, bool fail_on_error]) returns text @@ -794,6 +794,10 @@ SELECT dblink_open('foo', 'select proname, prosrc from pg_proc'); + + dblink_fetch + + dblink_fetch 3 @@ -804,10 +808,6 @@ SELECT dblink_open('foo', 'select proname, prosrc from pg_proc'); returns rows from an open cursor in a remote database - - dblink_fetch - - dblink_fetch(text cursorname, int howmany [, bool fail_on_error]) returns setof record @@ -947,6 +947,10 @@ SELECT * FROM dblink_fetch('foo', 5) AS (funcname name, source text); + + dblink_close + + dblink_close 3 @@ -957,10 +961,6 @@ SELECT * FROM dblink_fetch('foo', 5) AS (funcname name, source text); closes a cursor in a remote database - - dblink_close - - dblink_close(text cursorname [, bool fail_on_error]) returns text @@ -1058,6 +1058,10 @@ SELECT dblink_close('foo'); + + dblink_get_connections + + dblink_get_connections 3 @@ -1068,10 +1072,6 @@ SELECT dblink_close('foo'); returns the names of all open named dblink connections - - dblink_get_connections - - dblink_get_connections() returns text[] @@ -1103,6 +1103,10 @@ SELECT dblink_get_connections(); + + dblink_error_message + + dblink_error_message 3 @@ -1113,10 +1117,6 @@ SELECT dblink_get_connections(); gets last error message on the named connection - - dblink_error_message - - dblink_error_message(text connname) returns text @@ -1166,6 +1166,10 @@ SELECT dblink_error_message('dtest1'); + + dblink_send_query + + dblink_send_query 3 @@ -1176,10 +1180,6 @@ SELECT dblink_error_message('dtest1'); sends an async query to a remote database - - dblink_send_query - - dblink_send_query(text connname, text sql) returns int @@ -1248,6 +1248,10 @@ SELECT dblink_send_query('dtest1', 'SELECT * FROM foo WHERE f1 < 3'); + + dblink_is_busy + + dblink_is_busy 3 @@ -1258,10 +1262,6 @@ SELECT dblink_send_query('dtest1', 'SELECT * FROM foo WHERE f1 < 3'); checks if connection is busy with an async query - - dblink_is_busy - - dblink_is_busy(text connname) returns int @@ -1311,6 +1311,10 @@ SELECT dblink_is_busy('dtest1'); + + dblink_get_notify + + dblink_get_notify 3 @@ -1321,10 +1325,6 @@ SELECT dblink_is_busy('dtest1'); retrieve async notifications on a connection - - dblink_get_notify - - dblink_get_notify() returns setof (notify_name text, be_pid int, extra text) @@ -1393,6 +1393,10 @@ SELECT * FROM dblink_get_notify(); + + dblink_get_result + + dblink_get_result 3 @@ -1403,10 +1407,6 @@ SELECT * FROM dblink_get_notify(); gets an async query result - - dblink_get_result - - dblink_get_result(text connname [, bool fail_on_error]) returns setof record @@ -1557,6 +1557,10 @@ contrib_regression=# SELECT * FROM dblink_get_result('dtest1') AS t1(f1 int, f2 + + dblink_cancel_query + + dblink_cancel_query 3 @@ -1567,10 +1571,6 @@ contrib_regression=# SELECT * FROM dblink_get_result('dtest1') AS t1(f1 int, f2 cancels any active query on the named connection - - dblink_cancel_query - - dblink_cancel_query(text connname) returns text @@ -1625,6 +1625,10 @@ SELECT dblink_cancel_query('dtest1'); + + dblink_get_pkey + + dblink_get_pkey 3 @@ -1637,10 +1641,6 @@ SELECT dblink_cancel_query('dtest1'); - - dblink_get_pkey - - dblink_get_pkey(text relname) returns setof dblink_pkey_results @@ -1717,6 +1717,10 @@ SELECT * FROM dblink_get_pkey('foobar'); + + dblink_build_sql_insert + + dblink_build_sql_insert 3 @@ -1730,10 +1734,6 @@ SELECT * FROM dblink_get_pkey('foobar'); - - dblink_build_sql_insert - - dblink_build_sql_insert(text relname, @@ -1852,6 +1852,10 @@ SELECT dblink_build_sql_insert('foo', '1 2', 2, '{"1", "a"}', '{"1", "b''a"}'); + + dblink_build_sql_delete + + dblink_build_sql_delete 3 @@ -1864,10 +1868,6 @@ SELECT dblink_build_sql_insert('foo', '1 2', 2, '{"1", "a"}', '{"1", "b''a"}'); - - dblink_build_sql_delete - - dblink_build_sql_delete(text relname, @@ -1970,6 +1970,10 @@ SELECT dblink_build_sql_delete('"MyFoo"', '1 2', 2, '{"1", "b"}'); + + dblink_build_sql_update + + dblink_build_sql_update 3 @@ -1982,10 +1986,6 @@ SELECT dblink_build_sql_delete('"MyFoo"', '1 2', 2, '{"1", "b"}'); - - dblink_build_sql_update - - dblink_build_sql_update(text relname, diff --git a/doc/src/sgml/oid2name.sgml b/doc/src/sgml/oid2name.sgml index 5e39677496..97b170a23f 100644 --- a/doc/src/sgml/oid2name.sgml +++ b/doc/src/sgml/oid2name.sgml @@ -1,6 +1,10 @@ + + oid2name + + oid2name 1 @@ -12,10 +16,6 @@ resolve OIDs and file nodes in a PostgreSQL data directory - - oid2name - - oid2name diff --git a/doc/src/sgml/pg_xlogdump.sgml b/doc/src/sgml/pg_xlogdump.sgml index 0f29141342..1739622119 100644 --- a/doc/src/sgml/pg_xlogdump.sgml +++ b/doc/src/sgml/pg_xlogdump.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + pg_xlogdump + + pg_xlogdump 1 @@ -15,10 +19,6 @@ PostgreSQL documentation Display a human-readable rendering of the write-ahead log of a PostgreSQL database cluster - - pg_xlogdump - - pg_xlogdump diff --git a/doc/src/sgml/pgarchivecleanup.sgml b/doc/src/sgml/pgarchivecleanup.sgml index 932914bc2f..fdf0cbb9d1 100644 --- a/doc/src/sgml/pgarchivecleanup.sgml +++ b/doc/src/sgml/pgarchivecleanup.sgml @@ -1,6 +1,10 @@ + + pg_archivecleanup + + pg_archivecleanup 1 @@ -12,10 +16,6 @@ clean up PostgreSQL WAL archive files - - pg_archivecleanup - - pg_archivecleanup diff --git a/doc/src/sgml/pgbench.sgml b/doc/src/sgml/pgbench.sgml index 05ca9b76ab..4367563a37 100644 --- a/doc/src/sgml/pgbench.sgml +++ b/doc/src/sgml/pgbench.sgml @@ -1,6 +1,10 @@ + + pgbench + + pgbench 1 @@ -12,10 +16,6 @@ run a benchmark test on PostgreSQL - - pgbench - - pgbench diff --git a/doc/src/sgml/pgstandby.sgml b/doc/src/sgml/pgstandby.sgml index ca2b5c078d..fb3f32eaaa 100644 --- a/doc/src/sgml/pgstandby.sgml +++ b/doc/src/sgml/pgstandby.sgml @@ -1,6 +1,10 @@ + + pg_standby + + pg_standby 1 @@ -12,10 +16,6 @@ supports the creation of a PostgreSQL warm standby server - - pg_standby - - pg_standby diff --git a/doc/src/sgml/pgtestfsync.sgml b/doc/src/sgml/pgtestfsync.sgml index 45f0919125..c4b4014b1a 100644 --- a/doc/src/sgml/pgtestfsync.sgml +++ b/doc/src/sgml/pgtestfsync.sgml @@ -1,6 +1,10 @@ + + pg_test_fsync + + pg_test_fsync 1 @@ -12,10 +16,6 @@ determine fastest wal_sync_method for PostgreSQL - - pg_test_fsync - - pg_test_fsync diff --git a/doc/src/sgml/pgtesttiming.sgml b/doc/src/sgml/pgtesttiming.sgml index a2581d269c..a6ab9b114b 100644 --- a/doc/src/sgml/pgtesttiming.sgml +++ b/doc/src/sgml/pgtesttiming.sgml @@ -1,6 +1,10 @@ + + pg_test_timing + + pg_test_timing 1 @@ -12,10 +16,6 @@ measure timing overhead - - pg_test_timing - - pg_test_timing diff --git a/doc/src/sgml/pgupgrade.sgml b/doc/src/sgml/pgupgrade.sgml index 3da451cca2..4d03b12f11 100644 --- a/doc/src/sgml/pgupgrade.sgml +++ b/doc/src/sgml/pgupgrade.sgml @@ -1,6 +1,10 @@ + + pg_upgrade + + pg_upgrade 1 @@ -12,10 +16,6 @@ upgrade a PostgreSQL server instance - - pg_upgrade - - pg_upgrade diff --git a/doc/src/sgml/ref/abort.sgml b/doc/src/sgml/ref/abort.sgml index e9138d5702..ed9332c395 100644 --- a/doc/src/sgml/ref/abort.sgml +++ b/doc/src/sgml/ref/abort.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ABORT + + ABORT 7 @@ -15,10 +19,6 @@ PostgreSQL documentation abort the current transaction - - ABORT - - ABORT [ WORK | TRANSACTION ] diff --git a/doc/src/sgml/ref/alter_aggregate.sgml b/doc/src/sgml/ref/alter_aggregate.sgml index 641d19cceb..f92b8e5da3 100644 --- a/doc/src/sgml/ref/alter_aggregate.sgml +++ b/doc/src/sgml/ref/alter_aggregate.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER AGGREGATE + + ALTER AGGREGATE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of an aggregate function - - ALTER AGGREGATE - - ALTER AGGREGATE name ( aggregate_signature ) RENAME TO new_name diff --git a/doc/src/sgml/ref/alter_collation.sgml b/doc/src/sgml/ref/alter_collation.sgml index ebb30b8860..11ecd93c20 100644 --- a/doc/src/sgml/ref/alter_collation.sgml +++ b/doc/src/sgml/ref/alter_collation.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER COLLATION + + ALTER COLLATION 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of a collation - - ALTER COLLATION - - ALTER COLLATION name RENAME TO new_name diff --git a/doc/src/sgml/ref/alter_conversion.sgml b/doc/src/sgml/ref/alter_conversion.sgml index 4cc335b18e..a3f68975bf 100644 --- a/doc/src/sgml/ref/alter_conversion.sgml +++ b/doc/src/sgml/ref/alter_conversion.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER CONVERSION + + ALTER CONVERSION 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of a conversion - - ALTER CONVERSION - - ALTER CONVERSION name RENAME TO new_name diff --git a/doc/src/sgml/ref/alter_database.sgml b/doc/src/sgml/ref/alter_database.sgml index 360732fd35..23ef75512f 100644 --- a/doc/src/sgml/ref/alter_database.sgml +++ b/doc/src/sgml/ref/alter_database.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER DATABASE + + ALTER DATABASE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change a database - - ALTER DATABASE - - ALTER DATABASE name [ [ WITH ] option [ ... ] ] diff --git a/doc/src/sgml/ref/alter_default_privileges.sgml b/doc/src/sgml/ref/alter_default_privileges.sgml index fdd9c83800..04064d399c 100644 --- a/doc/src/sgml/ref/alter_default_privileges.sgml +++ b/doc/src/sgml/ref/alter_default_privileges.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER DEFAULT PRIVILEGES + + ALTER DEFAULT PRIVILEGES 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define default access privileges - - ALTER DEFAULT PRIVILEGES - - ALTER DEFAULT PRIVILEGES diff --git a/doc/src/sgml/ref/alter_domain.sgml b/doc/src/sgml/ref/alter_domain.sgml index c59975af03..db7b819835 100644 --- a/doc/src/sgml/ref/alter_domain.sgml +++ b/doc/src/sgml/ref/alter_domain.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER DOMAIN + + ALTER DOMAIN 7 @@ -17,10 +21,6 @@ PostgreSQL documentation - - ALTER DOMAIN - - ALTER DOMAIN name diff --git a/doc/src/sgml/ref/alter_event_trigger.sgml b/doc/src/sgml/ref/alter_event_trigger.sgml index f53b0228bc..1bf9d8abb6 100644 --- a/doc/src/sgml/ref/alter_event_trigger.sgml +++ b/doc/src/sgml/ref/alter_event_trigger.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER EVENT TRIGGER + + ALTER EVENT TRIGGER 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of an event trigger - - ALTER EVENT TRIGGER - - ALTER EVENT TRIGGER name DISABLE diff --git a/doc/src/sgml/ref/alter_extension.sgml b/doc/src/sgml/ref/alter_extension.sgml index 56fa30d2d3..0d479c8ca2 100644 --- a/doc/src/sgml/ref/alter_extension.sgml +++ b/doc/src/sgml/ref/alter_extension.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER EXTENSION + + ALTER EXTENSION 7 @@ -17,10 +21,6 @@ PostgreSQL documentation - - ALTER EXTENSION - - ALTER EXTENSION name UPDATE [ TO new_version ] diff --git a/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml b/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml index 91ac1b2f0c..1c82db9e03 100644 --- a/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml +++ b/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER FOREIGN DATA WRAPPER + + ALTER FOREIGN DATA WRAPPER 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of a foreign-data wrapper - - ALTER FOREIGN DATA WRAPPER - - ALTER FOREIGN DATA WRAPPER name diff --git a/doc/src/sgml/ref/alter_foreign_table.sgml b/doc/src/sgml/ref/alter_foreign_table.sgml index 723aa075c5..4d8cfc522e 100644 --- a/doc/src/sgml/ref/alter_foreign_table.sgml +++ b/doc/src/sgml/ref/alter_foreign_table.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER FOREIGN TABLE + + ALTER FOREIGN TABLE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of a foreign table - - ALTER FOREIGN TABLE - - ALTER FOREIGN TABLE [ IF EXISTS ] name diff --git a/doc/src/sgml/ref/alter_function.sgml b/doc/src/sgml/ref/alter_function.sgml index 013b6f8401..ba879eb1ea 100644 --- a/doc/src/sgml/ref/alter_function.sgml +++ b/doc/src/sgml/ref/alter_function.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER FUNCTION + + ALTER FUNCTION 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of a function - - ALTER FUNCTION - - ALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, ...] ] ) diff --git a/doc/src/sgml/ref/alter_group.sgml b/doc/src/sgml/ref/alter_group.sgml index 177b11d28d..143224286a 100644 --- a/doc/src/sgml/ref/alter_group.sgml +++ b/doc/src/sgml/ref/alter_group.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER GROUP + + ALTER GROUP 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change role name or membership - - ALTER GROUP - - ALTER GROUP group_name ADD USER user_name [, ... ] diff --git a/doc/src/sgml/ref/alter_index.sgml b/doc/src/sgml/ref/alter_index.sgml index d210077036..94a7af0429 100644 --- a/doc/src/sgml/ref/alter_index.sgml +++ b/doc/src/sgml/ref/alter_index.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER INDEX + + ALTER INDEX 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of an index - - ALTER INDEX - - ALTER INDEX [ IF EXISTS ] name RENAME TO new_name diff --git a/doc/src/sgml/ref/alter_language.sgml b/doc/src/sgml/ref/alter_language.sgml index ab23d624ba..5c9ded6837 100644 --- a/doc/src/sgml/ref/alter_language.sgml +++ b/doc/src/sgml/ref/alter_language.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER LANGUAGE + + ALTER LANGUAGE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of a procedural language - - ALTER LANGUAGE - - ALTER [ PROCEDURAL ] LANGUAGE name RENAME TO new_name diff --git a/doc/src/sgml/ref/alter_large_object.sgml b/doc/src/sgml/ref/alter_large_object.sgml index bcf532c80b..a6dabca1b2 100644 --- a/doc/src/sgml/ref/alter_large_object.sgml +++ b/doc/src/sgml/ref/alter_large_object.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER LARGE OBJECT + + ALTER LARGE OBJECT 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of a large object - - ALTER LARGE OBJECT - - ALTER LARGE OBJECT large_object_oid OWNER TO new_owner diff --git a/doc/src/sgml/ref/alter_materialized_view.sgml b/doc/src/sgml/ref/alter_materialized_view.sgml index e5617067f6..1932eeb84d 100644 --- a/doc/src/sgml/ref/alter_materialized_view.sgml +++ b/doc/src/sgml/ref/alter_materialized_view.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER MATERIALIZED VIEW + + ALTER MATERIALIZED VIEW 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of a materialized view - - ALTER MATERIALIZED VIEW - - ALTER MATERIALIZED VIEW [ IF EXISTS ] name diff --git a/doc/src/sgml/ref/alter_opclass.sgml b/doc/src/sgml/ref/alter_opclass.sgml index c70f6cd6a2..fc41d86661 100644 --- a/doc/src/sgml/ref/alter_opclass.sgml +++ b/doc/src/sgml/ref/alter_opclass.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER OPERATOR CLASS + + ALTER OPERATOR CLASS 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of an operator class - - ALTER OPERATOR CLASS - - ALTER OPERATOR CLASS name USING index_method RENAME TO new_name diff --git a/doc/src/sgml/ref/alter_operator.sgml b/doc/src/sgml/ref/alter_operator.sgml index 32bde5af7c..6075416320 100644 --- a/doc/src/sgml/ref/alter_operator.sgml +++ b/doc/src/sgml/ref/alter_operator.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER OPERATOR + + ALTER OPERATOR 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of an operator - - ALTER OPERATOR - - ALTER OPERATOR name ( { left_type | NONE } , { right_type | NONE } ) OWNER TO new_owner diff --git a/doc/src/sgml/ref/alter_opfamily.sgml b/doc/src/sgml/ref/alter_opfamily.sgml index aad968d284..55b912611d 100644 --- a/doc/src/sgml/ref/alter_opfamily.sgml +++ b/doc/src/sgml/ref/alter_opfamily.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER OPERATOR FAMILY + + ALTER OPERATOR FAMILY 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of an operator family - - ALTER OPERATOR FAMILY - - ALTER OPERATOR FAMILY name USING index_method ADD diff --git a/doc/src/sgml/ref/alter_role.sgml b/doc/src/sgml/ref/alter_role.sgml index b0981fdd5d..bcd46d5e4d 100644 --- a/doc/src/sgml/ref/alter_role.sgml +++ b/doc/src/sgml/ref/alter_role.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER ROLE + + ALTER ROLE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change a database role - - ALTER ROLE - - ALTER ROLE name [ [ WITH ] option [ ... ] ] diff --git a/doc/src/sgml/ref/alter_rule.sgml b/doc/src/sgml/ref/alter_rule.sgml index 0a186605a0..993a0ceb83 100644 --- a/doc/src/sgml/ref/alter_rule.sgml +++ b/doc/src/sgml/ref/alter_rule.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER RULE + + ALTER RULE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of a rule - - ALTER RULE - - ALTER RULE name ON table_name RENAME TO new_name diff --git a/doc/src/sgml/ref/alter_schema.sgml b/doc/src/sgml/ref/alter_schema.sgml index 020b113a32..00395c02f8 100644 --- a/doc/src/sgml/ref/alter_schema.sgml +++ b/doc/src/sgml/ref/alter_schema.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER SCHEMA + + ALTER SCHEMA 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of a schema - - ALTER SCHEMA - - ALTER SCHEMA name RENAME TO new_name diff --git a/doc/src/sgml/ref/alter_sequence.sgml b/doc/src/sgml/ref/alter_sequence.sgml index 204ca11f0b..9ba9bc4622 100644 --- a/doc/src/sgml/ref/alter_sequence.sgml +++ b/doc/src/sgml/ref/alter_sequence.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER SEQUENCE + + ALTER SEQUENCE 7 @@ -17,10 +21,6 @@ PostgreSQL documentation - - ALTER SEQUENCE - - ALTER SEQUENCE [ IF EXISTS ] name [ INCREMENT [ BY ] increment ] diff --git a/doc/src/sgml/ref/alter_server.sgml b/doc/src/sgml/ref/alter_server.sgml index 08afde1dd0..68253b9166 100644 --- a/doc/src/sgml/ref/alter_server.sgml +++ b/doc/src/sgml/ref/alter_server.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER SERVER + + ALTER SERVER 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of a foreign server - - ALTER SERVER - - ALTER SERVER name [ VERSION 'new_version' ] diff --git a/doc/src/sgml/ref/alter_system.sgml b/doc/src/sgml/ref/alter_system.sgml index 3ccc6afd51..081b3722a0 100644 --- a/doc/src/sgml/ref/alter_system.sgml +++ b/doc/src/sgml/ref/alter_system.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER SYSTEM + + ALTER SYSTEM 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change a server configuration parameter - - ALTER SYSTEM - - ALTER SYSTEM SET configuration_parameter { TO | = } { value | 'value' | DEFAULT } diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index 89649a2aa4..2b02e668e0 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER TABLE + + ALTER TABLE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of a table - - ALTER TABLE - - ALTER TABLE [ IF EXISTS ] [ ONLY ] name [ * ] diff --git a/doc/src/sgml/ref/alter_tablespace.sgml b/doc/src/sgml/ref/alter_tablespace.sgml index 99ee08a8da..5c98bc7f06 100644 --- a/doc/src/sgml/ref/alter_tablespace.sgml +++ b/doc/src/sgml/ref/alter_tablespace.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER TABLESPACE + + ALTER TABLESPACE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of a tablespace or affect objects of a tablespace - - ALTER TABLESPACE - - ALTER TABLESPACE name RENAME TO new_name diff --git a/doc/src/sgml/ref/alter_trigger.sgml b/doc/src/sgml/ref/alter_trigger.sgml index 0d70167024..c63b5dfa02 100644 --- a/doc/src/sgml/ref/alter_trigger.sgml +++ b/doc/src/sgml/ref/alter_trigger.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER TRIGGER + + ALTER TRIGGER 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of a trigger - - ALTER TRIGGER - - ALTER TRIGGER name ON table_name RENAME TO new_name diff --git a/doc/src/sgml/ref/alter_tsconfig.sgml b/doc/src/sgml/ref/alter_tsconfig.sgml index deef329b29..1a40d88f6a 100644 --- a/doc/src/sgml/ref/alter_tsconfig.sgml +++ b/doc/src/sgml/ref/alter_tsconfig.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER TEXT SEARCH CONFIGURATION + + ALTER TEXT SEARCH CONFIGURATION 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of a text search configuration - - ALTER TEXT SEARCH CONFIGURATION - - ALTER TEXT SEARCH CONFIGURATION name diff --git a/doc/src/sgml/ref/alter_tsdictionary.sgml b/doc/src/sgml/ref/alter_tsdictionary.sgml index 7c12037041..590c4fc6e1 100644 --- a/doc/src/sgml/ref/alter_tsdictionary.sgml +++ b/doc/src/sgml/ref/alter_tsdictionary.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER TEXT SEARCH DICTIONARY + + ALTER TEXT SEARCH DICTIONARY 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of a text search dictionary - - ALTER TEXT SEARCH DICTIONARY - - ALTER TEXT SEARCH DICTIONARY name ( diff --git a/doc/src/sgml/ref/alter_tsparser.sgml b/doc/src/sgml/ref/alter_tsparser.sgml index 8c082433b0..e2b6060a17 100644 --- a/doc/src/sgml/ref/alter_tsparser.sgml +++ b/doc/src/sgml/ref/alter_tsparser.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER TEXT SEARCH PARSER + + ALTER TEXT SEARCH PARSER 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of a text search parser - - ALTER TEXT SEARCH PARSER - - ALTER TEXT SEARCH PARSER name RENAME TO new_name diff --git a/doc/src/sgml/ref/alter_tstemplate.sgml b/doc/src/sgml/ref/alter_tstemplate.sgml index e4f0ff3b1e..e7ae91c0a0 100644 --- a/doc/src/sgml/ref/alter_tstemplate.sgml +++ b/doc/src/sgml/ref/alter_tstemplate.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER TEXT SEARCH TEMPLATE + + ALTER TEXT SEARCH TEMPLATE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of a text search template - - ALTER TEXT SEARCH TEMPLATE - - ALTER TEXT SEARCH TEMPLATE name RENAME TO new_name diff --git a/doc/src/sgml/ref/alter_type.sgml b/doc/src/sgml/ref/alter_type.sgml index 6700023b34..7724c11c78 100644 --- a/doc/src/sgml/ref/alter_type.sgml +++ b/doc/src/sgml/ref/alter_type.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER TYPE + + ALTER TYPE 7 @@ -17,10 +21,6 @@ PostgreSQL documentation - - ALTER TYPE - - ALTER TYPE name action [, ... ] diff --git a/doc/src/sgml/ref/alter_user.sgml b/doc/src/sgml/ref/alter_user.sgml index 7588f636ed..58ae1da127 100644 --- a/doc/src/sgml/ref/alter_user.sgml +++ b/doc/src/sgml/ref/alter_user.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER USER + + ALTER USER 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change a database role - - ALTER USER - - ALTER USER name [ [ WITH ] option [ ... ] ] diff --git a/doc/src/sgml/ref/alter_user_mapping.sgml b/doc/src/sgml/ref/alter_user_mapping.sgml index 3245f83e08..d0ddd1370b 100644 --- a/doc/src/sgml/ref/alter_user_mapping.sgml +++ b/doc/src/sgml/ref/alter_user_mapping.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER USER MAPPING + + ALTER USER MAPPING 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of a user mapping - - ALTER USER MAPPING - - ALTER USER MAPPING FOR { user_name | USER | CURRENT_USER | PUBLIC } diff --git a/doc/src/sgml/ref/alter_view.sgml b/doc/src/sgml/ref/alter_view.sgml index cbec3ab54e..cdcc4f126b 100644 --- a/doc/src/sgml/ref/alter_view.sgml +++ b/doc/src/sgml/ref/alter_view.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ALTER VIEW + + ALTER VIEW 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the definition of a view - - ALTER VIEW - - ALTER VIEW [ IF EXISTS ] name ALTER [ COLUMN ] column_name SET DEFAULT expression diff --git a/doc/src/sgml/ref/analyze.sgml b/doc/src/sgml/ref/analyze.sgml index 8063e3752e..08d316a9e4 100644 --- a/doc/src/sgml/ref/analyze.sgml +++ b/doc/src/sgml/ref/analyze.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ANALYZE + + ANALYZE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation collect statistics about a database - - ANALYZE - - ANALYZE [ VERBOSE ] [ table_name [ ( column_name [, ...] ) ] ] diff --git a/doc/src/sgml/ref/begin.sgml b/doc/src/sgml/ref/begin.sgml index acd823206a..c04f1c8064 100644 --- a/doc/src/sgml/ref/begin.sgml +++ b/doc/src/sgml/ref/begin.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + BEGIN + + BEGIN 7 @@ -15,10 +19,6 @@ PostgreSQL documentation start a transaction block - - BEGIN - - BEGIN [ WORK | TRANSACTION ] [ transaction_mode [, ...] ] diff --git a/doc/src/sgml/ref/checkpoint.sgml b/doc/src/sgml/ref/checkpoint.sgml index e70b8c8cb4..fa4dcc4f27 100644 --- a/doc/src/sgml/ref/checkpoint.sgml +++ b/doc/src/sgml/ref/checkpoint.sgml @@ -1,6 +1,10 @@ + + CHECKPOINT + + CHECKPOINT 7 @@ -12,10 +16,6 @@ force a transaction log checkpoint - - CHECKPOINT - - CHECKPOINT diff --git a/doc/src/sgml/ref/close.sgml b/doc/src/sgml/ref/close.sgml index 4af6af7492..aacc667144 100644 --- a/doc/src/sgml/ref/close.sgml +++ b/doc/src/sgml/ref/close.sgml @@ -4,6 +4,15 @@ PostgreSQL documentation --> + + CLOSE + + + + cursor + CLOSE + + CLOSE 7 @@ -15,15 +24,6 @@ PostgreSQL documentation close a cursor - - CLOSE - - - - cursor - CLOSE - - CLOSE { name | ALL } diff --git a/doc/src/sgml/ref/cluster.sgml b/doc/src/sgml/ref/cluster.sgml index 339990fa4d..2ab090d03e 100644 --- a/doc/src/sgml/ref/cluster.sgml +++ b/doc/src/sgml/ref/cluster.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CLUSTER + + CLUSTER 7 @@ -15,10 +19,6 @@ PostgreSQL documentation cluster a table according to an index - - CLUSTER - - CLUSTER [VERBOSE] table_name [ USING index_name ] diff --git a/doc/src/sgml/ref/clusterdb.sgml b/doc/src/sgml/ref/clusterdb.sgml index 1316932450..c13d74853e 100644 --- a/doc/src/sgml/ref/clusterdb.sgml +++ b/doc/src/sgml/ref/clusterdb.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + clusterdb + + clusterdb 1 @@ -15,10 +19,6 @@ PostgreSQL documentation cluster a PostgreSQL database - - clusterdb - - clusterdb diff --git a/doc/src/sgml/ref/comment.sgml b/doc/src/sgml/ref/comment.sgml index 1b2949f64f..53eadcdcc7 100644 --- a/doc/src/sgml/ref/comment.sgml +++ b/doc/src/sgml/ref/comment.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + COMMENT + + COMMENT 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define or change the comment of an object - - COMMENT - - COMMENT ON diff --git a/doc/src/sgml/ref/commit.sgml b/doc/src/sgml/ref/commit.sgml index 40147a5476..e93c216849 100644 --- a/doc/src/sgml/ref/commit.sgml +++ b/doc/src/sgml/ref/commit.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + COMMIT + + COMMIT 7 @@ -15,10 +19,6 @@ PostgreSQL documentation commit the current transaction - - COMMIT - - COMMIT [ WORK | TRANSACTION ] diff --git a/doc/src/sgml/ref/commit_prepared.sgml b/doc/src/sgml/ref/commit_prepared.sgml index ecd0c525f2..e1988ad318 100644 --- a/doc/src/sgml/ref/commit_prepared.sgml +++ b/doc/src/sgml/ref/commit_prepared.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + COMMIT PREPARED + + COMMIT PREPARED 7 @@ -15,10 +19,6 @@ PostgreSQL documentation commit a transaction that was earlier prepared for two-phase commit - - COMMIT PREPARED - - COMMIT PREPARED transaction_id diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml index 1ecc939eea..99f246af17 100644 --- a/doc/src/sgml/ref/copy.sgml +++ b/doc/src/sgml/ref/copy.sgml @@ -5,6 +5,10 @@ PostgreSQL documentation + + COPY + + COPY 7 @@ -16,10 +20,6 @@ PostgreSQL documentation copy data between a file and a table - - COPY - - COPY table_name [ ( column_name [, ...] ) ] diff --git a/doc/src/sgml/ref/create_aggregate.sgml b/doc/src/sgml/ref/create_aggregate.sgml index d15fcbae95..e5fc718654 100644 --- a/doc/src/sgml/ref/create_aggregate.sgml +++ b/doc/src/sgml/ref/create_aggregate.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE AGGREGATE + + CREATE AGGREGATE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new aggregate function - - CREATE AGGREGATE - - CREATE AGGREGATE name ( [ argmode ] [ argname ] arg_data_type [ , ... ] ) ( diff --git a/doc/src/sgml/ref/create_cast.sgml b/doc/src/sgml/ref/create_cast.sgml index 29ea298a46..2e69a10a8e 100644 --- a/doc/src/sgml/ref/create_cast.sgml +++ b/doc/src/sgml/ref/create_cast.sgml @@ -1,6 +1,10 @@ + + CREATE CAST + + CREATE CAST 7 @@ -12,10 +16,6 @@ define a new cast - - CREATE CAST - - CREATE CAST (source_type AS target_type) diff --git a/doc/src/sgml/ref/create_collation.sgml b/doc/src/sgml/ref/create_collation.sgml index c853576814..d757cdfb43 100644 --- a/doc/src/sgml/ref/create_collation.sgml +++ b/doc/src/sgml/ref/create_collation.sgml @@ -1,6 +1,10 @@ + + CREATE COLLATION + + CREATE COLLATION 7 @@ -12,10 +16,6 @@ define a new collation - - CREATE COLLATION - - CREATE COLLATION name ( diff --git a/doc/src/sgml/ref/create_conversion.sgml b/doc/src/sgml/ref/create_conversion.sgml index 084b60c4c1..d2e2c010ef 100644 --- a/doc/src/sgml/ref/create_conversion.sgml +++ b/doc/src/sgml/ref/create_conversion.sgml @@ -1,6 +1,10 @@ + + CREATE CONVERSION + + CREATE CONVERSION 7 @@ -12,10 +16,6 @@ define a new encoding conversion - - CREATE CONVERSION - - CREATE [ DEFAULT ] CONVERSION name diff --git a/doc/src/sgml/ref/create_database.sgml b/doc/src/sgml/ref/create_database.sgml index 5158854841..8e99761b69 100644 --- a/doc/src/sgml/ref/create_database.sgml +++ b/doc/src/sgml/ref/create_database.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE DATABASE + + CREATE DATABASE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation create a new database - - CREATE DATABASE - - CREATE DATABASE name diff --git a/doc/src/sgml/ref/create_domain.sgml b/doc/src/sgml/ref/create_domain.sgml index 49db069f89..dd782e48dc 100644 --- a/doc/src/sgml/ref/create_domain.sgml +++ b/doc/src/sgml/ref/create_domain.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE DOMAIN + + CREATE DOMAIN 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new domain - - CREATE DOMAIN - - CREATE DOMAIN name [ AS ] data_type diff --git a/doc/src/sgml/ref/create_event_trigger.sgml b/doc/src/sgml/ref/create_event_trigger.sgml index ed66322596..7cdf4c75f6 100644 --- a/doc/src/sgml/ref/create_event_trigger.sgml +++ b/doc/src/sgml/ref/create_event_trigger.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE EVENT TRIGGER + + CREATE EVENT TRIGGER 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new event trigger - - CREATE EVENT TRIGGER - - CREATE EVENT TRIGGER name diff --git a/doc/src/sgml/ref/create_extension.sgml b/doc/src/sgml/ref/create_extension.sgml index 9c9bf6ff7d..a1e7e4f812 100644 --- a/doc/src/sgml/ref/create_extension.sgml +++ b/doc/src/sgml/ref/create_extension.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE EXTENSION + + CREATE EXTENSION 7 @@ -15,10 +19,6 @@ PostgreSQL documentation install an extension - - CREATE EXTENSION - - CREATE EXTENSION [ IF NOT EXISTS ] extension_name diff --git a/doc/src/sgml/ref/create_foreign_data_wrapper.sgml b/doc/src/sgml/ref/create_foreign_data_wrapper.sgml index cbe50021f4..a3811a3b63 100644 --- a/doc/src/sgml/ref/create_foreign_data_wrapper.sgml +++ b/doc/src/sgml/ref/create_foreign_data_wrapper.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE FOREIGN DATA WRAPPER + + CREATE FOREIGN DATA WRAPPER 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new foreign-data wrapper - - CREATE FOREIGN DATA WRAPPER - - CREATE FOREIGN DATA WRAPPER name diff --git a/doc/src/sgml/ref/create_foreign_table.sgml b/doc/src/sgml/ref/create_foreign_table.sgml index 1ef4b5e9d7..06a70879c9 100644 --- a/doc/src/sgml/ref/create_foreign_table.sgml +++ b/doc/src/sgml/ref/create_foreign_table.sgml @@ -1,6 +1,10 @@ + + CREATE FOREIGN TABLE + + CREATE FOREIGN TABLE 7 @@ -12,10 +16,6 @@ define a new foreign table - - CREATE FOREIGN TABLE - - CREATE FOREIGN TABLE [ IF NOT EXISTS ] table_name ( [ diff --git a/doc/src/sgml/ref/create_function.sgml b/doc/src/sgml/ref/create_function.sgml index b61b9785ee..2001921535 100644 --- a/doc/src/sgml/ref/create_function.sgml +++ b/doc/src/sgml/ref/create_function.sgml @@ -3,6 +3,10 @@ doc/src/sgml/ref/create_function.sgml --> + + CREATE FUNCTION + + CREATE FUNCTION 7 @@ -14,10 +18,6 @@ doc/src/sgml/ref/create_function.sgml define a new function - - CREATE FUNCTION - - CREATE [ OR REPLACE ] FUNCTION diff --git a/doc/src/sgml/ref/create_group.sgml b/doc/src/sgml/ref/create_group.sgml index 3a84c8358a..981ce51e5f 100644 --- a/doc/src/sgml/ref/create_group.sgml +++ b/doc/src/sgml/ref/create_group.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE GROUP + + CREATE GROUP 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new database role - - CREATE GROUP - - CREATE GROUP name [ [ WITH ] option [ ... ] ] diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml index 9a6a683e12..e469b17e16 100644 --- a/doc/src/sgml/ref/create_index.sgml +++ b/doc/src/sgml/ref/create_index.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE INDEX + + CREATE INDEX 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new index - - CREATE INDEX - - CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ name ] ON table_name [ USING method ] diff --git a/doc/src/sgml/ref/create_language.sgml b/doc/src/sgml/ref/create_language.sgml index 0995b13623..41da16d977 100644 --- a/doc/src/sgml/ref/create_language.sgml +++ b/doc/src/sgml/ref/create_language.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE LANGUAGE + + CREATE LANGUAGE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new procedural language - - CREATE LANGUAGE - - CREATE [ OR REPLACE ] [ PROCEDURAL ] LANGUAGE name diff --git a/doc/src/sgml/ref/create_materialized_view.sgml b/doc/src/sgml/ref/create_materialized_view.sgml index b742e17ac8..2c73852ae3 100644 --- a/doc/src/sgml/ref/create_materialized_view.sgml +++ b/doc/src/sgml/ref/create_materialized_view.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE MATERIALIZED VIEW + + CREATE MATERIALIZED VIEW 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new materialized view - - CREATE MATERIALIZED VIEW - - CREATE MATERIALIZED VIEW table_name diff --git a/doc/src/sgml/ref/create_opclass.sgml b/doc/src/sgml/ref/create_opclass.sgml index 81b9e538af..b21a1a13b3 100644 --- a/doc/src/sgml/ref/create_opclass.sgml +++ b/doc/src/sgml/ref/create_opclass.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE OPERATOR CLASS + + CREATE OPERATOR CLASS 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new operator class - - CREATE OPERATOR CLASS - - CREATE OPERATOR CLASS name [ DEFAULT ] FOR TYPE data_type diff --git a/doc/src/sgml/ref/create_operator.sgml b/doc/src/sgml/ref/create_operator.sgml index dd33f065af..818e3a2315 100644 --- a/doc/src/sgml/ref/create_operator.sgml +++ b/doc/src/sgml/ref/create_operator.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE OPERATOR + + CREATE OPERATOR 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new operator - - CREATE OPERATOR - - CREATE OPERATOR name ( diff --git a/doc/src/sgml/ref/create_opfamily.sgml b/doc/src/sgml/ref/create_opfamily.sgml index 5bee54419a..c4bcf0863e 100644 --- a/doc/src/sgml/ref/create_opfamily.sgml +++ b/doc/src/sgml/ref/create_opfamily.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE OPERATOR FAMILY + + CREATE OPERATOR FAMILY 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new operator family - - CREATE OPERATOR FAMILY - - CREATE OPERATOR FAMILY name USING index_method diff --git a/doc/src/sgml/ref/create_role.sgml b/doc/src/sgml/ref/create_role.sgml index 7ec4d0a8e4..641e3500c9 100644 --- a/doc/src/sgml/ref/create_role.sgml +++ b/doc/src/sgml/ref/create_role.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE ROLE + + CREATE ROLE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new database role - - CREATE ROLE - - CREATE ROLE name [ [ WITH ] option [ ... ] ] diff --git a/doc/src/sgml/ref/create_rule.sgml b/doc/src/sgml/ref/create_rule.sgml index ab2f1ba55c..d3212b5e5a 100644 --- a/doc/src/sgml/ref/create_rule.sgml +++ b/doc/src/sgml/ref/create_rule.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE RULE + + CREATE RULE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new rewrite rule - - CREATE RULE - - CREATE [ OR REPLACE ] RULE name AS ON event diff --git a/doc/src/sgml/ref/create_schema.sgml b/doc/src/sgml/ref/create_schema.sgml index 550acf1a53..45e4637ab5 100644 --- a/doc/src/sgml/ref/create_schema.sgml +++ b/doc/src/sgml/ref/create_schema.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE SCHEMA + + CREATE SCHEMA 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new schema - - CREATE SCHEMA - - CREATE SCHEMA schema_name [ AUTHORIZATION user_name ] [ schema_element [ ... ] ] diff --git a/doc/src/sgml/ref/create_sequence.sgml b/doc/src/sgml/ref/create_sequence.sgml index 38d160d4ac..70b9f3d110 100644 --- a/doc/src/sgml/ref/create_sequence.sgml +++ b/doc/src/sgml/ref/create_sequence.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE SEQUENCE + + CREATE SEQUENCE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new sequence generator - - CREATE SEQUENCE - - CREATE [ TEMPORARY | TEMP ] SEQUENCE name [ INCREMENT [ BY ] increment ] diff --git a/doc/src/sgml/ref/create_server.sgml b/doc/src/sgml/ref/create_server.sgml index 3e6127a389..734c6c9fe8 100644 --- a/doc/src/sgml/ref/create_server.sgml +++ b/doc/src/sgml/ref/create_server.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE SERVER + + CREATE SERVER 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new foreign server - - CREATE SERVER - - CREATE SERVER server_name [ TYPE 'server_type' ] [ VERSION 'server_version' ] diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 7a01c63d5f..fc7ad09786 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE TABLE + + CREATE TABLE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new table - - CREATE TABLE - - CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name ( [ diff --git a/doc/src/sgml/ref/create_table_as.sgml b/doc/src/sgml/ref/create_table_as.sgml index 29c80405bf..b353a43761 100644 --- a/doc/src/sgml/ref/create_table_as.sgml +++ b/doc/src/sgml/ref/create_table_as.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE TABLE AS + + CREATE TABLE AS 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new table from the results of a query - - CREATE TABLE AS - - CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE table_name diff --git a/doc/src/sgml/ref/create_tablespace.sgml b/doc/src/sgml/ref/create_tablespace.sgml index 04c5fb8a1d..b643565057 100644 --- a/doc/src/sgml/ref/create_tablespace.sgml +++ b/doc/src/sgml/ref/create_tablespace.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE TABLESPACE + + CREATE TABLESPACE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new tablespace - - CREATE TABLESPACE - - CREATE TABLESPACE tablespace_name diff --git a/doc/src/sgml/ref/create_trigger.sgml b/doc/src/sgml/ref/create_trigger.sgml index e5ec738a48..a8fba49e4c 100644 --- a/doc/src/sgml/ref/create_trigger.sgml +++ b/doc/src/sgml/ref/create_trigger.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE TRIGGER + + CREATE TRIGGER 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new trigger - - CREATE TRIGGER - - CREATE [ CONSTRAINT ] TRIGGER name { BEFORE | AFTER | INSTEAD OF } { event [ OR ... ] } diff --git a/doc/src/sgml/ref/create_tsconfig.sgml b/doc/src/sgml/ref/create_tsconfig.sgml index c34d1c0a22..63321520df 100644 --- a/doc/src/sgml/ref/create_tsconfig.sgml +++ b/doc/src/sgml/ref/create_tsconfig.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE TEXT SEARCH CONFIGURATION + + CREATE TEXT SEARCH CONFIGURATION 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new text search configuration - - CREATE TEXT SEARCH CONFIGURATION - - CREATE TEXT SEARCH CONFIGURATION name ( diff --git a/doc/src/sgml/ref/create_tsdictionary.sgml b/doc/src/sgml/ref/create_tsdictionary.sgml index 2673bc5df7..9c95c11608 100644 --- a/doc/src/sgml/ref/create_tsdictionary.sgml +++ b/doc/src/sgml/ref/create_tsdictionary.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE TEXT SEARCH DICTIONARY + + CREATE TEXT SEARCH DICTIONARY 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new text search dictionary - - CREATE TEXT SEARCH DICTIONARY - - CREATE TEXT SEARCH DICTIONARY name ( diff --git a/doc/src/sgml/ref/create_tsparser.sgml b/doc/src/sgml/ref/create_tsparser.sgml index 7643f0852d..044581f6f2 100644 --- a/doc/src/sgml/ref/create_tsparser.sgml +++ b/doc/src/sgml/ref/create_tsparser.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE TEXT SEARCH PARSER + + CREATE TEXT SEARCH PARSER 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new text search parser - - CREATE TEXT SEARCH PARSER - - CREATE TEXT SEARCH PARSER name ( diff --git a/doc/src/sgml/ref/create_tstemplate.sgml b/doc/src/sgml/ref/create_tstemplate.sgml index 532419c703..360ad41f35 100644 --- a/doc/src/sgml/ref/create_tstemplate.sgml +++ b/doc/src/sgml/ref/create_tstemplate.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE TEXT SEARCH TEMPLATE + + CREATE TEXT SEARCH TEMPLATE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new text search template - - CREATE TEXT SEARCH TEMPLATE - - CREATE TEXT SEARCH TEMPLATE name ( diff --git a/doc/src/sgml/ref/create_type.sgml b/doc/src/sgml/ref/create_type.sgml index 606efeee86..e5d7992bbf 100644 --- a/doc/src/sgml/ref/create_type.sgml +++ b/doc/src/sgml/ref/create_type.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE TYPE + + CREATE TYPE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new data type - - CREATE TYPE - - CREATE TYPE name AS diff --git a/doc/src/sgml/ref/create_user.sgml b/doc/src/sgml/ref/create_user.sgml index 3ef2be1767..065999c85a 100644 --- a/doc/src/sgml/ref/create_user.sgml +++ b/doc/src/sgml/ref/create_user.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE USER + + CREATE USER 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new database role - - CREATE USER - - CREATE USER name [ [ WITH ] option [ ... ] ] diff --git a/doc/src/sgml/ref/create_user_mapping.sgml b/doc/src/sgml/ref/create_user_mapping.sgml index c7cc4ce574..bb0c9c0b03 100644 --- a/doc/src/sgml/ref/create_user_mapping.sgml +++ b/doc/src/sgml/ref/create_user_mapping.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE USER MAPPING + + CREATE USER MAPPING 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new mapping of a user to a foreign server - - CREATE USER MAPPING - - CREATE USER MAPPING FOR { user_name | USER | CURRENT_USER | PUBLIC } diff --git a/doc/src/sgml/ref/create_view.sgml b/doc/src/sgml/ref/create_view.sgml index e0fbe1e5e5..57bfae3084 100644 --- a/doc/src/sgml/ref/create_view.sgml +++ b/doc/src/sgml/ref/create_view.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + CREATE VIEW + + CREATE VIEW 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new view - - CREATE VIEW - - CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] [ RECURSIVE ] VIEW name [ ( column_name [, ...] ) ] diff --git a/doc/src/sgml/ref/createdb.sgml b/doc/src/sgml/ref/createdb.sgml index 7dbedc2e90..c363bd4a56 100644 --- a/doc/src/sgml/ref/createdb.sgml +++ b/doc/src/sgml/ref/createdb.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + createdb + + createdb 1 @@ -15,10 +19,6 @@ PostgreSQL documentation create a new PostgreSQL database - - createdb - - createdb diff --git a/doc/src/sgml/ref/createlang.sgml b/doc/src/sgml/ref/createlang.sgml index 2bc43627e5..e9c95d3278 100644 --- a/doc/src/sgml/ref/createlang.sgml +++ b/doc/src/sgml/ref/createlang.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + createlang + + createlang 1 @@ -15,10 +19,6 @@ PostgreSQL documentation install a PostgreSQL procedural language - - createlang - - createlang diff --git a/doc/src/sgml/ref/createuser.sgml b/doc/src/sgml/ref/createuser.sgml index 63d4c6c4a8..4332008c68 100644 --- a/doc/src/sgml/ref/createuser.sgml +++ b/doc/src/sgml/ref/createuser.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + createuser + + createuser 1 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new PostgreSQL user account - - createuser - - createuser diff --git a/doc/src/sgml/ref/deallocate.sgml b/doc/src/sgml/ref/deallocate.sgml index 950c4e835d..394b125f52 100644 --- a/doc/src/sgml/ref/deallocate.sgml +++ b/doc/src/sgml/ref/deallocate.sgml @@ -4,6 +4,15 @@ PostgreSQL documentation --> + + DEALLOCATE + + + + prepared statements + removing + + DEALLOCATE 7 @@ -15,15 +24,6 @@ PostgreSQL documentation deallocate a prepared statement - - DEALLOCATE - - - - prepared statements - removing - - DEALLOCATE [ PREPARE ] { name | ALL } diff --git a/doc/src/sgml/ref/declare.sgml b/doc/src/sgml/ref/declare.sgml index d500faaa74..5cb85cc568 100644 --- a/doc/src/sgml/ref/declare.sgml +++ b/doc/src/sgml/ref/declare.sgml @@ -4,6 +4,15 @@ PostgreSQL documentation --> + + DECLARE + + + + cursor + DECLARE + + DECLARE 7 @@ -15,15 +24,6 @@ PostgreSQL documentation define a cursor - - DECLARE - - - - cursor - DECLARE - - DECLARE name [ BINARY ] [ INSENSITIVE ] [ [ NO ] SCROLL ] diff --git a/doc/src/sgml/ref/delete.sgml b/doc/src/sgml/ref/delete.sgml index 5d2ad3fde5..74ea90787b 100644 --- a/doc/src/sgml/ref/delete.sgml +++ b/doc/src/sgml/ref/delete.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DELETE + + DELETE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation delete rows of a table - - DELETE - - [ WITH [ RECURSIVE ] with_query [, ...] ] diff --git a/doc/src/sgml/ref/discard.sgml b/doc/src/sgml/ref/discard.sgml index 762f865711..5b06a638c5 100644 --- a/doc/src/sgml/ref/discard.sgml +++ b/doc/src/sgml/ref/discard.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DISCARD + + DISCARD 7 @@ -15,10 +19,6 @@ PostgreSQL documentation discard session state - - DISCARD - - DISCARD { ALL | PLANS | SEQUENCES | TEMPORARY | TEMP } diff --git a/doc/src/sgml/ref/do.sgml b/doc/src/sgml/ref/do.sgml index 5f43d1cf52..ed5e588ee7 100644 --- a/doc/src/sgml/ref/do.sgml +++ b/doc/src/sgml/ref/do.sgml @@ -4,6 +4,14 @@ PostgreSQL documentation --> + + DO + + + + anonymous code blocks + + DO 7 @@ -15,14 +23,6 @@ PostgreSQL documentation execute an anonymous code block - - DO - - - - anonymous code blocks - - DO [ LANGUAGE lang_name ] code diff --git a/doc/src/sgml/ref/drop_aggregate.sgml b/doc/src/sgml/ref/drop_aggregate.sgml index e89e76268f..37683e51ef 100644 --- a/doc/src/sgml/ref/drop_aggregate.sgml +++ b/doc/src/sgml/ref/drop_aggregate.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP AGGREGATE + + DROP AGGREGATE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove an aggregate function - - DROP AGGREGATE - - DROP AGGREGATE [ IF EXISTS ] name ( aggregate_signature ) [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_cast.sgml b/doc/src/sgml/ref/drop_cast.sgml index 589c6ac39b..dae3a39fce 100644 --- a/doc/src/sgml/ref/drop_cast.sgml +++ b/doc/src/sgml/ref/drop_cast.sgml @@ -1,6 +1,10 @@ + + DROP CAST + + DROP CAST 7 @@ -12,10 +16,6 @@ remove a cast - - DROP CAST - - DROP CAST [ IF EXISTS ] (source_type AS target_type) [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_collation.sgml b/doc/src/sgml/ref/drop_collation.sgml index 64a48eec2b..f00c88679b 100644 --- a/doc/src/sgml/ref/drop_collation.sgml +++ b/doc/src/sgml/ref/drop_collation.sgml @@ -1,6 +1,10 @@ + + DROP COLLATION + + DROP COLLATION 7 @@ -12,10 +16,6 @@ remove a collation - - DROP COLLATION - - DROP COLLATION [ IF EXISTS ] name [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_conversion.sgml b/doc/src/sgml/ref/drop_conversion.sgml index 6f866438fb..1a33b3dcc5 100644 --- a/doc/src/sgml/ref/drop_conversion.sgml +++ b/doc/src/sgml/ref/drop_conversion.sgml @@ -1,6 +1,10 @@ + + DROP CONVERSION + + DROP CONVERSION 7 @@ -12,10 +16,6 @@ remove a conversion - - DROP CONVERSION - - DROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_database.sgml b/doc/src/sgml/ref/drop_database.sgml index 89ee7b2507..740aa31995 100644 --- a/doc/src/sgml/ref/drop_database.sgml +++ b/doc/src/sgml/ref/drop_database.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP DATABASE + + DROP DATABASE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a database - - DROP DATABASE - - DROP DATABASE [ IF EXISTS ] name diff --git a/doc/src/sgml/ref/drop_domain.sgml b/doc/src/sgml/ref/drop_domain.sgml index b7b9a167c1..995d09ec8e 100644 --- a/doc/src/sgml/ref/drop_domain.sgml +++ b/doc/src/sgml/ref/drop_domain.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP DOMAIN + + DROP DOMAIN 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a domain - - DROP DOMAIN - - DROP DOMAIN [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_event_trigger.sgml b/doc/src/sgml/ref/drop_event_trigger.sgml index 86f9628fd8..cf42e15061 100644 --- a/doc/src/sgml/ref/drop_event_trigger.sgml +++ b/doc/src/sgml/ref/drop_event_trigger.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP EVENT TRIGGER + + DROP EVENT TRIGGER 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove an event trigger - - DROP EVENT TRIGGER - - DROP EVENT TRIGGER [ IF EXISTS ] name [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_extension.sgml b/doc/src/sgml/ref/drop_extension.sgml index bcc5cfe780..3bb9d9cb4c 100644 --- a/doc/src/sgml/ref/drop_extension.sgml +++ b/doc/src/sgml/ref/drop_extension.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP EXTENSION + + DROP EXTENSION 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove an extension - - DROP EXTENSION - - DROP EXTENSION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_foreign_data_wrapper.sgml b/doc/src/sgml/ref/drop_foreign_data_wrapper.sgml index 18fa4fe4a5..e43e0bda8b 100644 --- a/doc/src/sgml/ref/drop_foreign_data_wrapper.sgml +++ b/doc/src/sgml/ref/drop_foreign_data_wrapper.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP FOREIGN DATA WRAPPER + + DROP FOREIGN DATA WRAPPER 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a foreign-data wrapper - - DROP FOREIGN DATA WRAPPER - - DROP FOREIGN DATA WRAPPER [ IF EXISTS ] name [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_foreign_table.sgml b/doc/src/sgml/ref/drop_foreign_table.sgml index 1f66126a33..3c6376413e 100644 --- a/doc/src/sgml/ref/drop_foreign_table.sgml +++ b/doc/src/sgml/ref/drop_foreign_table.sgml @@ -1,6 +1,10 @@ + + DROP FOREIGN TABLE + + DROP FOREIGN TABLE 7 @@ -12,10 +16,6 @@ remove a foreign table - - DROP FOREIGN TABLE - - DROP FOREIGN TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_function.sgml b/doc/src/sgml/ref/drop_function.sgml index 2d0048be28..51b8ede5fb 100644 --- a/doc/src/sgml/ref/drop_function.sgml +++ b/doc/src/sgml/ref/drop_function.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP FUNCTION + + DROP FUNCTION 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a function - - DROP FUNCTION - - DROP FUNCTION [ IF EXISTS ] name ( [ [ argmode ] [ argname ] argtype [, ...] ] ) diff --git a/doc/src/sgml/ref/drop_group.sgml b/doc/src/sgml/ref/drop_group.sgml index 57f686497e..e601ff4172 100644 --- a/doc/src/sgml/ref/drop_group.sgml +++ b/doc/src/sgml/ref/drop_group.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP GROUP + + DROP GROUP 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a database role - - DROP GROUP - - DROP GROUP [ IF EXISTS ] name [, ...] diff --git a/doc/src/sgml/ref/drop_index.sgml b/doc/src/sgml/ref/drop_index.sgml index 98fd9c966c..d66d30edf7 100644 --- a/doc/src/sgml/ref/drop_index.sgml +++ b/doc/src/sgml/ref/drop_index.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP INDEX + + DROP INDEX 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove an index - - DROP INDEX - - DROP INDEX [ CONCURRENTLY ] [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_language.sgml b/doc/src/sgml/ref/drop_language.sgml index c2cb7045de..defae43c1a 100644 --- a/doc/src/sgml/ref/drop_language.sgml +++ b/doc/src/sgml/ref/drop_language.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP LANGUAGE + + DROP LANGUAGE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a procedural language - - DROP LANGUAGE - - DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] name [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_materialized_view.sgml b/doc/src/sgml/ref/drop_materialized_view.sgml index 80d8acea36..f3ddfb06e8 100644 --- a/doc/src/sgml/ref/drop_materialized_view.sgml +++ b/doc/src/sgml/ref/drop_materialized_view.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP MATERIALIZED VIEW + + DROP MATERIALIZED VIEW 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a materialized view - - DROP MATERIALIZED VIEW - - DROP MATERIALIZED VIEW [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_opclass.sgml b/doc/src/sgml/ref/drop_opclass.sgml index a20293ce97..2ee8f883b6 100644 --- a/doc/src/sgml/ref/drop_opclass.sgml +++ b/doc/src/sgml/ref/drop_opclass.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP OPERATOR CLASS + + DROP OPERATOR CLASS 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove an operator class - - DROP OPERATOR CLASS - - DROP OPERATOR CLASS [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_operator.sgml b/doc/src/sgml/ref/drop_operator.sgml index 3091454fdc..902e4f3fa6 100644 --- a/doc/src/sgml/ref/drop_operator.sgml +++ b/doc/src/sgml/ref/drop_operator.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP OPERATOR + + DROP OPERATOR 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove an operator - - DROP OPERATOR - - DROP OPERATOR [ IF EXISTS ] name ( { left_type | NONE } , { right_type | NONE } ) [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_opfamily.sgml b/doc/src/sgml/ref/drop_opfamily.sgml index 4cc67ef053..d665e93883 100644 --- a/doc/src/sgml/ref/drop_opfamily.sgml +++ b/doc/src/sgml/ref/drop_opfamily.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP OPERATOR FAMILY + + DROP OPERATOR FAMILY 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove an operator family - - DROP OPERATOR FAMILY - - DROP OPERATOR FAMILY [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_owned.sgml b/doc/src/sgml/ref/drop_owned.sgml index 48cf0fa535..1cd8e60e40 100644 --- a/doc/src/sgml/ref/drop_owned.sgml +++ b/doc/src/sgml/ref/drop_owned.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP OWNED + + DROP OWNED 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove database objects owned by a database role - - DROP OWNED - - DROP OWNED BY name [, ...] [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_role.sgml b/doc/src/sgml/ref/drop_role.sgml index 92c0fb863d..9a93da624a 100644 --- a/doc/src/sgml/ref/drop_role.sgml +++ b/doc/src/sgml/ref/drop_role.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP ROLE + + DROP ROLE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a database role - - DROP ROLE - - DROP ROLE [ IF EXISTS ] name [, ...] diff --git a/doc/src/sgml/ref/drop_rule.sgml b/doc/src/sgml/ref/drop_rule.sgml index c845872566..16ab2b1bb5 100644 --- a/doc/src/sgml/ref/drop_rule.sgml +++ b/doc/src/sgml/ref/drop_rule.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP RULE + + DROP RULE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a rewrite rule - - DROP RULE - - DROP RULE [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_schema.sgml b/doc/src/sgml/ref/drop_schema.sgml index 15dbc40817..859f17e185 100644 --- a/doc/src/sgml/ref/drop_schema.sgml +++ b/doc/src/sgml/ref/drop_schema.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP SCHEMA + + DROP SCHEMA 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a schema - - DROP SCHEMA - - DROP SCHEMA [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_sequence.sgml b/doc/src/sgml/ref/drop_sequence.sgml index f810b5976c..b0f9cddda7 100644 --- a/doc/src/sgml/ref/drop_sequence.sgml +++ b/doc/src/sgml/ref/drop_sequence.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP SEQUENCE + + DROP SEQUENCE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a sequence - - DROP SEQUENCE - - DROP SEQUENCE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_server.sgml b/doc/src/sgml/ref/drop_server.sgml index a6e6743357..497d83fb4a 100644 --- a/doc/src/sgml/ref/drop_server.sgml +++ b/doc/src/sgml/ref/drop_server.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP SERVER + + DROP SERVER 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a foreign server descriptor - - DROP SERVER - - DROP SERVER [ IF EXISTS ] name [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_table.sgml b/doc/src/sgml/ref/drop_table.sgml index fc51c7c622..4cb1f49b3a 100644 --- a/doc/src/sgml/ref/drop_table.sgml +++ b/doc/src/sgml/ref/drop_table.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP TABLE + + DROP TABLE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a table - - DROP TABLE - - DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_tablespace.sgml b/doc/src/sgml/ref/drop_tablespace.sgml index 1db6ecd59a..d0a05af2e1 100644 --- a/doc/src/sgml/ref/drop_tablespace.sgml +++ b/doc/src/sgml/ref/drop_tablespace.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP TABLESPACE + + DROP TABLESPACE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a tablespace - - DROP TABLESPACE - - DROP TABLESPACE [ IF EXISTS ] name diff --git a/doc/src/sgml/ref/drop_trigger.sgml b/doc/src/sgml/ref/drop_trigger.sgml index 3ec6cc7f05..2067aefca2 100644 --- a/doc/src/sgml/ref/drop_trigger.sgml +++ b/doc/src/sgml/ref/drop_trigger.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP TRIGGER + + DROP TRIGGER 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a trigger - - DROP TRIGGER - - DROP TRIGGER [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_tsconfig.sgml b/doc/src/sgml/ref/drop_tsconfig.sgml index 8fcb0d3d5e..831485e6a6 100644 --- a/doc/src/sgml/ref/drop_tsconfig.sgml +++ b/doc/src/sgml/ref/drop_tsconfig.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP TEXT SEARCH CONFIGURATION + + DROP TEXT SEARCH CONFIGURATION 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a text search configuration - - DROP TEXT SEARCH CONFIGURATION - - DROP TEXT SEARCH CONFIGURATION [ IF EXISTS ] name [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_tsdictionary.sgml b/doc/src/sgml/ref/drop_tsdictionary.sgml index 12b88cd7d3..44b30cbe67 100644 --- a/doc/src/sgml/ref/drop_tsdictionary.sgml +++ b/doc/src/sgml/ref/drop_tsdictionary.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP TEXT SEARCH DICTIONARY + + DROP TEXT SEARCH DICTIONARY 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a text search dictionary - - DROP TEXT SEARCH DICTIONARY - - DROP TEXT SEARCH DICTIONARY [ IF EXISTS ] name [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_tsparser.sgml b/doc/src/sgml/ref/drop_tsparser.sgml index 860d7e20bb..789e807dbe 100644 --- a/doc/src/sgml/ref/drop_tsparser.sgml +++ b/doc/src/sgml/ref/drop_tsparser.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP TEXT SEARCH PARSER + + DROP TEXT SEARCH PARSER 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a text search parser - - DROP TEXT SEARCH PARSER - - DROP TEXT SEARCH PARSER [ IF EXISTS ] name [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_tstemplate.sgml b/doc/src/sgml/ref/drop_tstemplate.sgml index 8ad419d3ed..ebf8136744 100644 --- a/doc/src/sgml/ref/drop_tstemplate.sgml +++ b/doc/src/sgml/ref/drop_tstemplate.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP TEXT SEARCH TEMPLATE + + DROP TEXT SEARCH TEMPLATE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a text search template - - DROP TEXT SEARCH TEMPLATE - - DROP TEXT SEARCH TEMPLATE [ IF EXISTS ] name [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_type.sgml b/doc/src/sgml/ref/drop_type.sgml index c3ddfa5f42..98c8a3cbef 100644 --- a/doc/src/sgml/ref/drop_type.sgml +++ b/doc/src/sgml/ref/drop_type.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP TYPE + + DROP TYPE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a data type - - DROP TYPE - - DROP TYPE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/drop_user.sgml b/doc/src/sgml/ref/drop_user.sgml index 1bdf03c515..24e2a87ff2 100644 --- a/doc/src/sgml/ref/drop_user.sgml +++ b/doc/src/sgml/ref/drop_user.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP USER + + DROP USER 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a database role - - DROP USER - - DROP USER [ IF EXISTS ] name [, ...] diff --git a/doc/src/sgml/ref/drop_user_mapping.sgml b/doc/src/sgml/ref/drop_user_mapping.sgml index de21bfe5d7..ddfad0bcad 100644 --- a/doc/src/sgml/ref/drop_user_mapping.sgml +++ b/doc/src/sgml/ref/drop_user_mapping.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP USER MAPPING + + DROP USER MAPPING 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a user mapping for a foreign server - - DROP USER MAPPING - - DROP USER MAPPING [ IF EXISTS ] FOR { user_name | USER | CURRENT_USER | PUBLIC } SERVER server_name diff --git a/doc/src/sgml/ref/drop_view.sgml b/doc/src/sgml/ref/drop_view.sgml index 51b82664cb..8b43be5360 100644 --- a/doc/src/sgml/ref/drop_view.sgml +++ b/doc/src/sgml/ref/drop_view.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + DROP VIEW + + DROP VIEW 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a view - - DROP VIEW - - DROP VIEW [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] diff --git a/doc/src/sgml/ref/dropdb.sgml b/doc/src/sgml/ref/dropdb.sgml index 4593604f3b..16c49e7928 100644 --- a/doc/src/sgml/ref/dropdb.sgml +++ b/doc/src/sgml/ref/dropdb.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + dropdb + + dropdb 1 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a PostgreSQL database - - dropdb - - dropdb diff --git a/doc/src/sgml/ref/droplang.sgml b/doc/src/sgml/ref/droplang.sgml index 81b954a68f..86f05d6b05 100644 --- a/doc/src/sgml/ref/droplang.sgml +++ b/doc/src/sgml/ref/droplang.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + droplang + + droplang 1 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a PostgreSQL procedural language - - droplang - - droplang diff --git a/doc/src/sgml/ref/dropuser.sgml b/doc/src/sgml/ref/dropuser.sgml index 180fb0bb62..d7ad61b3d6 100644 --- a/doc/src/sgml/ref/dropuser.sgml +++ b/doc/src/sgml/ref/dropuser.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + dropuser + + dropuser 1 @@ -15,10 +19,6 @@ PostgreSQL documentation remove a PostgreSQL user account - - dropuser - - dropuser diff --git a/doc/src/sgml/ref/ecpg-ref.sgml b/doc/src/sgml/ref/ecpg-ref.sgml index edd20dcdd5..029bd4a4d2 100644 --- a/doc/src/sgml/ref/ecpg-ref.sgml +++ b/doc/src/sgml/ref/ecpg-ref.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ecpg + + ecpg 1 @@ -15,10 +19,6 @@ PostgreSQL documentation embedded SQL C preprocessor - - ecpg - - ecpg diff --git a/doc/src/sgml/ref/end.sgml b/doc/src/sgml/ref/end.sgml index b60cb2c48b..10e414515b 100644 --- a/doc/src/sgml/ref/end.sgml +++ b/doc/src/sgml/ref/end.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + END + + END 7 @@ -15,10 +19,6 @@ PostgreSQL documentation commit the current transaction - - END - - END [ WORK | TRANSACTION ] diff --git a/doc/src/sgml/ref/execute.sgml b/doc/src/sgml/ref/execute.sgml index 2c7308eaa5..76069c019e 100644 --- a/doc/src/sgml/ref/execute.sgml +++ b/doc/src/sgml/ref/execute.sgml @@ -4,6 +4,15 @@ PostgreSQL documentation --> + + EXECUTE + + + + prepared statements + executing + + EXECUTE 7 @@ -15,15 +24,6 @@ PostgreSQL documentation execute a prepared statement - - EXECUTE - - - - prepared statements - executing - - EXECUTE name [ ( parameter [, ...] ) ] diff --git a/doc/src/sgml/ref/explain.sgml b/doc/src/sgml/ref/explain.sgml index 0f579fb161..04a78ee82e 100644 --- a/doc/src/sgml/ref/explain.sgml +++ b/doc/src/sgml/ref/explain.sgml @@ -4,17 +4,6 @@ PostgreSQL documentation --> - - EXPLAIN - 7 - SQL - Language Statements - - - - EXPLAIN - show the execution plan of a statement - - EXPLAIN @@ -29,6 +18,17 @@ PostgreSQL documentation showing the query plan + + EXPLAIN + 7 + SQL - Language Statements + + + + EXPLAIN + show the execution plan of a statement + + EXPLAIN [ ( option [, ...] ) ] statement diff --git a/doc/src/sgml/ref/fetch.sgml b/doc/src/sgml/ref/fetch.sgml index cc49b6f0ce..24c8c49156 100644 --- a/doc/src/sgml/ref/fetch.sgml +++ b/doc/src/sgml/ref/fetch.sgml @@ -4,6 +4,15 @@ PostgreSQL documentation --> + + + FETCH + + + + cursor + FETCH + FETCH 7 @@ -15,15 +24,6 @@ PostgreSQL documentation retrieve rows from a query using a cursor - - FETCH - - - - cursor - FETCH - - diff --git a/doc/src/sgml/ref/grant.sgml b/doc/src/sgml/ref/grant.sgml index fc3552bc1d..f2b25e546c 100644 --- a/doc/src/sgml/ref/grant.sgml +++ b/doc/src/sgml/ref/grant.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + GRANT + + GRANT 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define access privileges - - GRANT - - GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER } diff --git a/doc/src/sgml/ref/initdb.sgml b/doc/src/sgml/ref/initdb.sgml index b1067e2350..228edf75da 100644 --- a/doc/src/sgml/ref/initdb.sgml +++ b/doc/src/sgml/ref/initdb.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + initdb + + initdb 1 @@ -15,10 +19,6 @@ PostgreSQL documentation create a new PostgreSQL database cluster - - initdb - - initdb diff --git a/doc/src/sgml/ref/insert.sgml b/doc/src/sgml/ref/insert.sgml index a3930beb38..a3cccb9f7c 100644 --- a/doc/src/sgml/ref/insert.sgml +++ b/doc/src/sgml/ref/insert.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + INSERT + + INSERT 7 @@ -15,10 +19,6 @@ PostgreSQL documentation create new rows in a table - - INSERT - - [ WITH [ RECURSIVE ] with_query [, ...] ] diff --git a/doc/src/sgml/ref/listen.sgml b/doc/src/sgml/ref/listen.sgml index 7287d3fc29..9cd53b02bb 100644 --- a/doc/src/sgml/ref/listen.sgml +++ b/doc/src/sgml/ref/listen.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + LISTEN + + LISTEN 7 @@ -15,10 +19,6 @@ PostgreSQL documentation listen for a notification - - LISTEN - - LISTEN channel diff --git a/doc/src/sgml/ref/load.sgml b/doc/src/sgml/ref/load.sgml index f44f313b5e..a5a6ef8e67 100644 --- a/doc/src/sgml/ref/load.sgml +++ b/doc/src/sgml/ref/load.sgml @@ -3,6 +3,10 @@ doc/src/sgml/ref/load.sgml --> + + LOAD + + LOAD 7 @@ -14,10 +18,6 @@ doc/src/sgml/ref/load.sgml load a shared library file - - LOAD - - LOAD 'filename' diff --git a/doc/src/sgml/ref/lock.sgml b/doc/src/sgml/ref/lock.sgml index 95d6767376..26e424b63e 100644 --- a/doc/src/sgml/ref/lock.sgml +++ b/doc/src/sgml/ref/lock.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + LOCK + + LOCK 7 @@ -15,10 +19,6 @@ PostgreSQL documentation lock a table - - LOCK - - LOCK [ TABLE ] [ ONLY ] name [ * ] [, ...] [ IN lockmode MODE ] [ NOWAIT ] diff --git a/doc/src/sgml/ref/move.sgml b/doc/src/sgml/ref/move.sgml index 231f537c86..ed64f23068 100644 --- a/doc/src/sgml/ref/move.sgml +++ b/doc/src/sgml/ref/move.sgml @@ -4,6 +4,15 @@ PostgreSQL documentation --> + + MOVE + + + + cursor + MOVE + + MOVE 7 @@ -15,15 +24,6 @@ PostgreSQL documentation position a cursor - - MOVE - - - - cursor - MOVE - - diff --git a/doc/src/sgml/ref/notify.sgml b/doc/src/sgml/ref/notify.sgml index 307d2f6282..ad574e9ea0 100644 --- a/doc/src/sgml/ref/notify.sgml +++ b/doc/src/sgml/ref/notify.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + NOTIFY + + NOTIFY 7 @@ -15,10 +19,6 @@ PostgreSQL documentation generate a notification - - NOTIFY - - NOTIFY channel [ , payload ] diff --git a/doc/src/sgml/ref/pg_basebackup.sgml b/doc/src/sgml/ref/pg_basebackup.sgml index ea2233123e..84b45ae7a0 100644 --- a/doc/src/sgml/ref/pg_basebackup.sgml +++ b/doc/src/sgml/ref/pg_basebackup.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + pg_basebackup + + pg_basebackup 1 @@ -15,10 +19,6 @@ PostgreSQL documentation take a base backup of a PostgreSQL cluster - - pg_basebackup - - pg_basebackup diff --git a/doc/src/sgml/ref/pg_config-ref.sgml b/doc/src/sgml/ref/pg_config-ref.sgml index 5aac38b3ce..9f6db9e39b 100644 --- a/doc/src/sgml/ref/pg_config-ref.sgml +++ b/doc/src/sgml/ref/pg_config-ref.sgml @@ -1,6 +1,10 @@ + + pg_config + + pg_config 1 @@ -12,10 +16,6 @@ retrieve information about the installed version of PostgreSQL - - pg_config - - pg_config diff --git a/doc/src/sgml/ref/pg_controldata.sgml b/doc/src/sgml/ref/pg_controldata.sgml index c9eebc089e..fbf40fcf9d 100644 --- a/doc/src/sgml/ref/pg_controldata.sgml +++ b/doc/src/sgml/ref/pg_controldata.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + pg_controldata + + pg_controldata 1 @@ -15,10 +19,6 @@ PostgreSQL documentation display control information of a PostgreSQL database cluster - - pg_controldata - - pg_controldata diff --git a/doc/src/sgml/ref/pg_ctl-ref.sgml b/doc/src/sgml/ref/pg_ctl-ref.sgml index 3107514901..45b53ce1a1 100644 --- a/doc/src/sgml/ref/pg_ctl-ref.sgml +++ b/doc/src/sgml/ref/pg_ctl-ref.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + pg_ctl + + pg_ctl 1 @@ -15,10 +19,6 @@ PostgreSQL documentation initialize, start, stop, or control a PostgreSQL server - - pg_ctl - - pg_ctl diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml index 8d45f24bd2..40c69f0542 100644 --- a/doc/src/sgml/ref/pg_dump.sgml +++ b/doc/src/sgml/ref/pg_dump.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + pg_dump + + pg_dump 1 @@ -18,10 +22,6 @@ PostgreSQL documentation - - pg_dump - - pg_dump diff --git a/doc/src/sgml/ref/pg_dumpall.sgml b/doc/src/sgml/ref/pg_dumpall.sgml index 5c6a101333..f33793985f 100644 --- a/doc/src/sgml/ref/pg_dumpall.sgml +++ b/doc/src/sgml/ref/pg_dumpall.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + pg_dumpall + + pg_dumpall 1 @@ -15,10 +19,6 @@ PostgreSQL documentation extract a PostgreSQL database cluster into a script file - - pg_dumpall - - pg_dumpall diff --git a/doc/src/sgml/ref/pg_isready.sgml b/doc/src/sgml/ref/pg_isready.sgml index bef6a44415..cadfe8eb08 100644 --- a/doc/src/sgml/ref/pg_isready.sgml +++ b/doc/src/sgml/ref/pg_isready.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + pg_isready + + pg_isready 1 @@ -15,10 +19,6 @@ PostgreSQL documentation check the connection status of a PostgreSQL server - - pg_isready - - pg_isready diff --git a/doc/src/sgml/ref/pg_receivexlog.sgml b/doc/src/sgml/ref/pg_receivexlog.sgml index f05e718094..78c105cc18 100644 --- a/doc/src/sgml/ref/pg_receivexlog.sgml +++ b/doc/src/sgml/ref/pg_receivexlog.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + pg_receivexlog + + pg_receivexlog 1 @@ -15,10 +19,6 @@ PostgreSQL documentation streams transaction logs from a PostgreSQL cluster - - pg_receivexlog - - pg_receivexlog diff --git a/doc/src/sgml/ref/pg_resetxlog.sgml b/doc/src/sgml/ref/pg_resetxlog.sgml index b5286650ce..34b0606955 100644 --- a/doc/src/sgml/ref/pg_resetxlog.sgml +++ b/doc/src/sgml/ref/pg_resetxlog.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + pg_resetxlog + + pg_resetxlog 1 @@ -15,10 +19,6 @@ PostgreSQL documentation reset the write-ahead log and other control information of a PostgreSQL database cluster - - pg_resetxlog - - pg_resetxlog diff --git a/doc/src/sgml/ref/pg_restore.sgml b/doc/src/sgml/ref/pg_restore.sgml index 717da4272d..cd60b2558a 100644 --- a/doc/src/sgml/ref/pg_restore.sgml +++ b/doc/src/sgml/ref/pg_restore.sgml @@ -1,6 +1,10 @@ + + pg_restore + + pg_restore 1 @@ -16,10 +20,6 @@ - - pg_restore - - pg_restore diff --git a/doc/src/sgml/ref/postgres-ref.sgml b/doc/src/sgml/ref/postgres-ref.sgml index 65fd0a29ff..8e225e4c5d 100644 --- a/doc/src/sgml/ref/postgres-ref.sgml +++ b/doc/src/sgml/ref/postgres-ref.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + postgres + + postgres 1 @@ -15,10 +19,6 @@ PostgreSQL documentation PostgreSQL database server - - postgres - - postgres diff --git a/doc/src/sgml/ref/postmaster.sgml b/doc/src/sgml/ref/postmaster.sgml index d66fe1c3de..0a58a63331 100644 --- a/doc/src/sgml/ref/postmaster.sgml +++ b/doc/src/sgml/ref/postmaster.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + postmaster + + postmaster 1 @@ -15,10 +19,6 @@ PostgreSQL documentation PostgreSQL database server - - postmaster - - postmaster diff --git a/doc/src/sgml/ref/prepare.sgml b/doc/src/sgml/ref/prepare.sgml index b1698f2bb8..dbce8f2ef2 100644 --- a/doc/src/sgml/ref/prepare.sgml +++ b/doc/src/sgml/ref/prepare.sgml @@ -4,6 +4,15 @@ PostgreSQL documentation --> + + PREPARE + + + + prepared statements + creating + + PREPARE 7 @@ -15,15 +24,6 @@ PostgreSQL documentation prepare a statement for execution - - PREPARE - - - - prepared statements - creating - - PREPARE name [ ( data_type [, ...] ) ] AS statement diff --git a/doc/src/sgml/ref/prepare_transaction.sgml b/doc/src/sgml/ref/prepare_transaction.sgml index a379819a0a..626753f576 100644 --- a/doc/src/sgml/ref/prepare_transaction.sgml +++ b/doc/src/sgml/ref/prepare_transaction.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + PREPARE TRANSACTION + + PREPARE TRANSACTION 7 @@ -15,10 +19,6 @@ PostgreSQL documentation prepare the current transaction for two-phase commit - - PREPARE TRANSACTION - - PREPARE TRANSACTION transaction_id diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index 94635c56ce..8813be8f2a 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + psql + + psql 1 @@ -17,10 +21,6 @@ PostgreSQL documentation - - psql - - psql diff --git a/doc/src/sgml/ref/reassign_owned.sgml b/doc/src/sgml/ref/reassign_owned.sgml index 0d6b1787e2..d7d6abb9d8 100644 --- a/doc/src/sgml/ref/reassign_owned.sgml +++ b/doc/src/sgml/ref/reassign_owned.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + REASSIGN OWNED + + REASSIGN OWNED 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change the ownership of database objects owned by a database role - - REASSIGN OWNED - - REASSIGN OWNED BY old_role [, ...] TO new_role diff --git a/doc/src/sgml/ref/refresh_materialized_view.sgml b/doc/src/sgml/ref/refresh_materialized_view.sgml index d2f8104aa7..c165c69c9f 100644 --- a/doc/src/sgml/ref/refresh_materialized_view.sgml +++ b/doc/src/sgml/ref/refresh_materialized_view.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + REFRESH MATERIALIZED VIEW + + REFRESH MATERIALIZED VIEW 7 @@ -15,10 +19,6 @@ PostgreSQL documentation replace the contents of a materialized view - - REFRESH MATERIALIZED VIEW - - REFRESH MATERIALIZED VIEW [ CONCURRENTLY ] name diff --git a/doc/src/sgml/ref/reindex.sgml b/doc/src/sgml/ref/reindex.sgml index 722266563e..54422c3442 100644 --- a/doc/src/sgml/ref/reindex.sgml +++ b/doc/src/sgml/ref/reindex.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + REINDEX + + REINDEX 7 @@ -15,10 +19,6 @@ PostgreSQL documentation rebuild indexes - - REINDEX - - REINDEX { INDEX | TABLE | DATABASE | SYSTEM } name [ FORCE ] diff --git a/doc/src/sgml/ref/reindexdb.sgml b/doc/src/sgml/ref/reindexdb.sgml index 3ba9951df8..486f5c9367 100644 --- a/doc/src/sgml/ref/reindexdb.sgml +++ b/doc/src/sgml/ref/reindexdb.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + reindexdb + + reindexdb 1 @@ -15,10 +19,6 @@ PostgreSQL documentation reindex a PostgreSQL database - - reindexdb - - reindexdb diff --git a/doc/src/sgml/ref/release_savepoint.sgml b/doc/src/sgml/ref/release_savepoint.sgml index 99b16d48e9..b331b7226b 100644 --- a/doc/src/sgml/ref/release_savepoint.sgml +++ b/doc/src/sgml/ref/release_savepoint.sgml @@ -4,6 +4,15 @@ PostgreSQL documentation --> + + RELEASE SAVEPOINT + + + + savepoints + releasing + + RELEASE SAVEPOINT 7 @@ -15,15 +24,6 @@ PostgreSQL documentation destroy a previously defined savepoint - - RELEASE SAVEPOINT - - - - savepoints - releasing - - RELEASE [ SAVEPOINT ] savepoint_name diff --git a/doc/src/sgml/ref/reset.sgml b/doc/src/sgml/ref/reset.sgml index d1ce7fb124..7e76891bde 100644 --- a/doc/src/sgml/ref/reset.sgml +++ b/doc/src/sgml/ref/reset.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + RESET + + RESET 7 @@ -15,10 +19,6 @@ PostgreSQL documentation restore the value of a run-time parameter to the default value - - RESET - - RESET configuration_parameter diff --git a/doc/src/sgml/ref/revoke.sgml b/doc/src/sgml/ref/revoke.sgml index d2c5a4a505..36c286bf0d 100644 --- a/doc/src/sgml/ref/revoke.sgml +++ b/doc/src/sgml/ref/revoke.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + REVOKE + + REVOKE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation remove access privileges - - REVOKE - - REVOKE [ GRANT OPTION FOR ] diff --git a/doc/src/sgml/ref/rollback.sgml b/doc/src/sgml/ref/rollback.sgml index 9a1529f0b4..b0b1e8d0e3 100644 --- a/doc/src/sgml/ref/rollback.sgml +++ b/doc/src/sgml/ref/rollback.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ROLLBACK + + ROLLBACK 7 @@ -15,10 +19,6 @@ PostgreSQL documentation abort the current transaction - - ROLLBACK - - ROLLBACK [ WORK | TRANSACTION ] diff --git a/doc/src/sgml/ref/rollback_prepared.sgml b/doc/src/sgml/ref/rollback_prepared.sgml index 514e5ae441..a5328e96a2 100644 --- a/doc/src/sgml/ref/rollback_prepared.sgml +++ b/doc/src/sgml/ref/rollback_prepared.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + ROLLBACK PREPARED + + ROLLBACK PREPARED 7 @@ -15,10 +19,6 @@ PostgreSQL documentation cancel a transaction that was earlier prepared for two-phase commit - - ROLLBACK PREPARED - - ROLLBACK PREPARED transaction_id diff --git a/doc/src/sgml/ref/rollback_to.sgml b/doc/src/sgml/ref/rollback_to.sgml index c21449af67..060f408a63 100644 --- a/doc/src/sgml/ref/rollback_to.sgml +++ b/doc/src/sgml/ref/rollback_to.sgml @@ -4,6 +4,15 @@ PostgreSQL documentation --> + + ROLLBACK TO SAVEPOINT + + + + savepoints + rolling back + + ROLLBACK TO SAVEPOINT 7 @@ -15,15 +24,6 @@ PostgreSQL documentation roll back to a savepoint - - ROLLBACK TO SAVEPOINT - - - - savepoints - rolling back - - ROLLBACK [ WORK | TRANSACTION ] TO [ SAVEPOINT ] savepoint_name diff --git a/doc/src/sgml/ref/savepoint.sgml b/doc/src/sgml/ref/savepoint.sgml index 2ea873bfc7..5b944a2561 100644 --- a/doc/src/sgml/ref/savepoint.sgml +++ b/doc/src/sgml/ref/savepoint.sgml @@ -4,6 +4,15 @@ PostgreSQL documentation --> + + SAVEPOINT + + + + savepoints + defining + + SAVEPOINT 7 @@ -15,15 +24,6 @@ PostgreSQL documentation define a new savepoint within the current transaction - - SAVEPOINT - - - - savepoints - defining - - SAVEPOINT savepoint_name diff --git a/doc/src/sgml/ref/security_label.sgml b/doc/src/sgml/ref/security_label.sgml index d7595654e4..6e2bd25240 100644 --- a/doc/src/sgml/ref/security_label.sgml +++ b/doc/src/sgml/ref/security_label.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + SECURITY LABEL + + SECURITY LABEL 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define or change a security label applied to an object - - SECURITY LABEL - - SECURITY LABEL [ FOR provider ] ON diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml index 9a468b98c0..7395754662 100644 --- a/doc/src/sgml/ref/select.sgml +++ b/doc/src/sgml/ref/select.sgml @@ -4,19 +4,6 @@ PostgreSQL documentation --> - - SELECT - 7 - SQL - Language Statements - - - - SELECT - TABLE - WITH - retrieve rows from a table or view - - SELECT @@ -30,6 +17,19 @@ PostgreSQL documentation in SELECT + + SELECT + 7 + SQL - Language Statements + + + + SELECT + TABLE + WITH + retrieve rows from a table or view + + [ WITH [ RECURSIVE ] with_query [, ...] ] diff --git a/doc/src/sgml/ref/select_into.sgml b/doc/src/sgml/ref/select_into.sgml index 48b789b580..cf16372528 100644 --- a/doc/src/sgml/ref/select_into.sgml +++ b/doc/src/sgml/ref/select_into.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + SELECT INTO + + SELECT INTO 7 @@ -15,10 +19,6 @@ PostgreSQL documentation define a new table from the results of a query - - SELECT INTO - - [ WITH [ RECURSIVE ] with_query [, ...] ] diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml index aaad61eb4f..4ebb6a627b 100644 --- a/doc/src/sgml/ref/set.sgml +++ b/doc/src/sgml/ref/set.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + SET + + SET 7 @@ -15,10 +19,6 @@ PostgreSQL documentation change a run-time parameter - - SET - - SET [ SESSION | LOCAL ] configuration_parameter { TO | = } { value | 'value' | DEFAULT } diff --git a/doc/src/sgml/ref/set_constraints.sgml b/doc/src/sgml/ref/set_constraints.sgml index 60cabeda3c..7c31871b0b 100644 --- a/doc/src/sgml/ref/set_constraints.sgml +++ b/doc/src/sgml/ref/set_constraints.sgml @@ -1,5 +1,9 @@ + + SET CONSTRAINTS + + SET CONSTRAINTS 7 @@ -11,10 +15,6 @@ set constraint check timing for the current transaction - - SET CONSTRAINTS - - SET CONSTRAINTS { ALL | name [, ...] } { DEFERRED | IMMEDIATE } diff --git a/doc/src/sgml/ref/set_role.sgml b/doc/src/sgml/ref/set_role.sgml index bb6ea5179f..8e2deb7635 100644 --- a/doc/src/sgml/ref/set_role.sgml +++ b/doc/src/sgml/ref/set_role.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + SET ROLE + + SET ROLE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation set the current user identifier of the current session - - SET ROLE - - SET [ SESSION | LOCAL ] ROLE role_name diff --git a/doc/src/sgml/ref/set_session_auth.sgml b/doc/src/sgml/ref/set_session_auth.sgml index 856b030127..4ac2128950 100644 --- a/doc/src/sgml/ref/set_session_auth.sgml +++ b/doc/src/sgml/ref/set_session_auth.sgml @@ -1,5 +1,9 @@ + + SET SESSION AUTHORIZATION + + SET SESSION AUTHORIZATION 7 @@ -11,10 +15,6 @@ set the session user identifier and the current user identifier of the current session - - SET SESSION AUTHORIZATION - - SET [ SESSION | LOCAL ] SESSION AUTHORIZATION user_name diff --git a/doc/src/sgml/ref/set_transaction.sgml b/doc/src/sgml/ref/set_transaction.sgml index 029b75a2bc..ca55a5b196 100644 --- a/doc/src/sgml/ref/set_transaction.sgml +++ b/doc/src/sgml/ref/set_transaction.sgml @@ -1,16 +1,5 @@ - - SET TRANSACTION - 7 - SQL - Language Statements - - - - SET TRANSACTION - set the characteristics of the current transaction - - SET TRANSACTION @@ -30,6 +19,17 @@ setting + + SET TRANSACTION + 7 + SQL - Language Statements + + + + SET TRANSACTION + set the characteristics of the current transaction + + SET TRANSACTION transaction_mode [, ...] diff --git a/doc/src/sgml/ref/show.sgml b/doc/src/sgml/ref/show.sgml index 4a6a3fc7fe..46bb239baf 100644 --- a/doc/src/sgml/ref/show.sgml +++ b/doc/src/sgml/ref/show.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + SHOW + + SHOW 7 @@ -15,10 +19,6 @@ PostgreSQL documentation show the value of a run-time parameter - - SHOW - - SHOW name diff --git a/doc/src/sgml/ref/start_transaction.sgml b/doc/src/sgml/ref/start_transaction.sgml index f25a3e9536..60926f5dfe 100644 --- a/doc/src/sgml/ref/start_transaction.sgml +++ b/doc/src/sgml/ref/start_transaction.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + START TRANSACTION + + START TRANSACTION 7 @@ -15,10 +19,6 @@ PostgreSQL documentation start a transaction block - - START TRANSACTION - - START TRANSACTION [ transaction_mode [, ...] ] diff --git a/doc/src/sgml/ref/truncate.sgml b/doc/src/sgml/ref/truncate.sgml index 7b9c2f3012..87516c9cc3 100644 --- a/doc/src/sgml/ref/truncate.sgml +++ b/doc/src/sgml/ref/truncate.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + TRUNCATE + + TRUNCATE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation empty a table or set of tables - - TRUNCATE - - TRUNCATE [ TABLE ] [ ONLY ] name [ * ] [, ... ] diff --git a/doc/src/sgml/ref/unlisten.sgml b/doc/src/sgml/ref/unlisten.sgml index c6436829d6..f7c3c47e2f 100644 --- a/doc/src/sgml/ref/unlisten.sgml +++ b/doc/src/sgml/ref/unlisten.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + UNLISTEN + + UNLISTEN 7 @@ -15,10 +19,6 @@ PostgreSQL documentation stop listening for a notification - - UNLISTEN - - UNLISTEN { channel | * } diff --git a/doc/src/sgml/ref/update.sgml b/doc/src/sgml/ref/update.sgml index 90b92085cd..7f565be3c2 100644 --- a/doc/src/sgml/ref/update.sgml +++ b/doc/src/sgml/ref/update.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + UPDATE + + UPDATE 7 @@ -15,10 +19,6 @@ PostgreSQL documentation update rows of a table - - UPDATE - - [ WITH [ RECURSIVE ] with_query [, ...] ] diff --git a/doc/src/sgml/ref/vacuum.sgml b/doc/src/sgml/ref/vacuum.sgml index 23c3ca89c7..450c94fcd3 100644 --- a/doc/src/sgml/ref/vacuum.sgml +++ b/doc/src/sgml/ref/vacuum.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + VACUUM + + VACUUM 7 @@ -15,10 +19,6 @@ PostgreSQL documentation garbage-collect and optionally analyze a database - - VACUUM - - VACUUM [ ( { FULL | FREEZE | VERBOSE | ANALYZE } [, ...] ) ] [ table_name [ (column_name [, ...] ) ] ] diff --git a/doc/src/sgml/ref/vacuumdb.sgml b/doc/src/sgml/ref/vacuumdb.sgml index a5216ec038..1c519f5944 100644 --- a/doc/src/sgml/ref/vacuumdb.sgml +++ b/doc/src/sgml/ref/vacuumdb.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + vacuumdb + + vacuumdb 1 @@ -15,10 +19,6 @@ PostgreSQL documentation garbage-collect and analyze a PostgreSQL database - - vacuumdb - - vacuumdb diff --git a/doc/src/sgml/ref/values.sgml b/doc/src/sgml/ref/values.sgml index 1f0e9a8ba1..0fb3cd7bc2 100644 --- a/doc/src/sgml/ref/values.sgml +++ b/doc/src/sgml/ref/values.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + VALUES + + VALUES 7 @@ -15,10 +19,6 @@ PostgreSQL documentation compute a set of rows - - VALUES - - VALUES ( expression [, ...] ) [, ...] diff --git a/doc/src/sgml/spi.sgml b/doc/src/sgml/spi.sgml index 079a4571fb..d8af07e5d2 100644 --- a/doc/src/sgml/spi.sgml +++ b/doc/src/sgml/spi.sgml @@ -63,6 +63,8 @@ Interface Functions + SPI_connect + SPI_connect 3 @@ -73,8 +75,6 @@ connect a procedure to the SPI manager - SPI_connect - int SPI_connect(void) @@ -135,6 +135,8 @@ int SPI_connect(void) + SPI_finish + SPI_finish 3 @@ -145,8 +147,6 @@ int SPI_connect(void) disconnect a procedure from the SPI manager - SPI_finish - int SPI_finish(void) @@ -201,6 +201,8 @@ int SPI_finish(void) + SPI_push + SPI_push 3 @@ -211,8 +213,6 @@ int SPI_finish(void) push SPI stack to allow recursive SPI usage - SPI_push - void SPI_push(void) @@ -249,6 +249,8 @@ void SPI_push(void) + SPI_pop + SPI_pop 3 @@ -259,8 +261,6 @@ void SPI_push(void) pop SPI stack to return from recursive SPI usage - SPI_pop - void SPI_pop(void) @@ -281,6 +281,8 @@ void SPI_pop(void) + SPI_execute + SPI_execute 3 @@ -291,8 +293,6 @@ void SPI_pop(void) execute a command - SPI_execute - int SPI_execute(const char * command, bool read_only, long count) @@ -637,6 +637,8 @@ typedef struct + SPI_exec + SPI_exec 3 @@ -647,8 +649,6 @@ typedef struct execute a read/write command - SPI_exec - int SPI_exec(const char * command, long count) @@ -703,6 +703,8 @@ int SPI_exec(const char * command, long count< + SPI_execute_with_args + SPI_execute_with_args 3 @@ -713,8 +715,6 @@ int SPI_exec(const char * command, long count< execute a command with out-of-line parameters - SPI_execute_with_args - int SPI_execute_with_args(const char *command, @@ -856,6 +856,8 @@ int SPI_execute_with_args(const char *command, + SPI_prepare + SPI_prepare 3 @@ -866,8 +868,6 @@ int SPI_execute_with_args(const char *command, prepare a statement, without executing it yet - SPI_prepare - SPIPlanPtr SPI_prepare(const char * command, int nargs, Oid * argtypes) @@ -1018,6 +1018,8 @@ SPIPlanPtr SPI_prepare(const char * command, int + SPI_prepare_cursor + SPI_prepare_cursor 3 @@ -1028,8 +1030,6 @@ SPIPlanPtr SPI_prepare(const char * command, int prepare a statement, without executing it yet - SPI_prepare_cursor - SPIPlanPtr SPI_prepare_cursor(const char * command, int nargs, @@ -1120,6 +1120,8 @@ SPIPlanPtr SPI_prepare_cursor(const char * command, int < + SPI_prepare_params + SPI_prepare_params 3 @@ -1130,8 +1132,6 @@ SPIPlanPtr SPI_prepare_cursor(const char * command, int < prepare a statement, without executing it yet - SPI_prepare_params - SPIPlanPtr SPI_prepare_params(const char * command, @@ -1208,6 +1208,8 @@ SPIPlanPtr SPI_prepare_params(const char * command, + SPI_getargcount + SPI_getargcount 3 @@ -1219,8 +1221,6 @@ SPIPlanPtr SPI_prepare_params(const char * command, prepared by SPI_prepare - SPI_getargcount - int SPI_getargcount(SPIPlanPtr plan) @@ -1265,6 +1265,8 @@ int SPI_getargcount(SPIPlanPtr plan) + SPI_getargtypeid + SPI_getargtypeid 3 @@ -1276,8 +1278,6 @@ int SPI_getargcount(SPIPlanPtr plan) a statement prepared by SPI_prepare - SPI_getargtypeid - Oid SPI_getargtypeid(SPIPlanPtr plan, int argIndex) @@ -1335,6 +1335,8 @@ Oid SPI_getargtypeid(SPIPlanPtr plan, int argI + SPI_is_cursor_plan + SPI_is_cursor_plan 3 @@ -1347,8 +1349,6 @@ Oid SPI_getargtypeid(SPIPlanPtr plan, int argI SPI_cursor_open - SPI_is_cursor_plan - bool SPI_is_cursor_plan(SPIPlanPtr plan) @@ -1404,6 +1404,8 @@ bool SPI_is_cursor_plan(SPIPlanPtr plan) + SPI_execute_plan + SPI_execute_plan 3 @@ -1414,8 +1416,6 @@ bool SPI_is_cursor_plan(SPIPlanPtr plan) execute a statement prepared by SPI_prepare - SPI_execute_plan - int SPI_execute_plan(SPIPlanPtr plan, Datum * values, const char * nulls, @@ -1540,6 +1540,8 @@ int SPI_execute_plan(SPIPlanPtr plan, Datum * + SPI_execute_plan_with_paramlist + SPI_execute_plan_with_paramlist 3 @@ -1550,8 +1552,6 @@ int SPI_execute_plan(SPIPlanPtr plan, Datum * execute a statement prepared by SPI_prepare - SPI_execute_plan_with_paramlist - int SPI_execute_plan_with_paramlist(SPIPlanPtr plan, @@ -1635,6 +1635,8 @@ int SPI_execute_plan_with_paramlist(SPIPlanPtr plan, + SPI_execp + SPI_execp 3 @@ -1645,8 +1647,6 @@ int SPI_execute_plan_with_paramlist(SPIPlanPtr plan, execute a statement in read/write mode - SPI_execp - int SPI_execp(SPIPlanPtr plan, Datum * values, const char * nulls, long count) @@ -1739,6 +1739,8 @@ int SPI_execp(SPIPlanPtr plan, Datum * values< + SPI_cursor_open + SPI_cursor_open 3 @@ -1749,8 +1751,6 @@ int SPI_execp(SPIPlanPtr plan, Datum * values< set up a cursor using a statement created with SPI_prepare - SPI_cursor_open - Portal SPI_cursor_open(const char * name, SPIPlanPtr plan, @@ -1863,6 +1863,8 @@ Portal SPI_cursor_open(const char * name, SPIPlanPtr + SPI_cursor_open_with_args + SPI_cursor_open_with_args 3 @@ -1873,8 +1875,6 @@ Portal SPI_cursor_open(const char * name, SPIPlanPtr set up a cursor using a query and parameters - SPI_cursor_open_with_args - Portal SPI_cursor_open_with_args(const char *name, @@ -2016,6 +2016,8 @@ Portal SPI_cursor_open_with_args(const char *name, + SPI_cursor_open_with_paramlist + SPI_cursor_open_with_paramlist 3 @@ -2026,8 +2028,6 @@ Portal SPI_cursor_open_with_args(const char *name, set up a cursor using parameters - SPI_cursor_open_with_paramlist - Portal SPI_cursor_open_with_paramlist(const char *name, @@ -2112,6 +2112,8 @@ Portal SPI_cursor_open_with_paramlist(const char *name, + SPI_cursor_find + SPI_cursor_find 3 @@ -2122,8 +2124,6 @@ Portal SPI_cursor_open_with_paramlist(const char *name, find an existing cursor by name - SPI_cursor_find - Portal SPI_cursor_find(const char * name) @@ -2168,6 +2168,8 @@ Portal SPI_cursor_find(const char * name) + SPI_cursor_fetch + SPI_cursor_fetch 3 @@ -2178,8 +2180,6 @@ Portal SPI_cursor_find(const char * name) fetch some rows from a cursor - SPI_cursor_fetch - void SPI_cursor_fetch(Portal portal, bool forward, long count) @@ -2253,6 +2253,8 @@ void SPI_cursor_fetch(Portal portal, bool forw + SPI_cursor_move + SPI_cursor_move 3 @@ -2263,8 +2265,6 @@ void SPI_cursor_fetch(Portal portal, bool forw move a cursor - SPI_cursor_move - void SPI_cursor_move(Portal portal, bool forward, long count) @@ -2328,6 +2328,8 @@ void SPI_cursor_move(Portal portal, bool forwa + SPI_scroll_cursor_fetch + SPI_scroll_cursor_fetch 3 @@ -2338,8 +2340,6 @@ void SPI_cursor_move(Portal portal, bool forwa fetch some rows from a cursor - SPI_scroll_cursor_fetch - void SPI_scroll_cursor_fetch(Portal portal, FetchDirection direction, @@ -2427,6 +2427,8 @@ void SPI_scroll_cursor_fetch(Portal portal, FetchDirectio + SPI_scroll_cursor_move + SPI_scroll_cursor_move 3 @@ -2437,8 +2439,6 @@ void SPI_scroll_cursor_fetch(Portal portal, FetchDirectio move a cursor - SPI_scroll_cursor_move - void SPI_scroll_cursor_move(Portal portal, FetchDirection direction, @@ -2528,6 +2528,8 @@ void SPI_scroll_cursor_move(Portal portal, FetchDirection + SPI_cursor_close + SPI_cursor_close 3 @@ -2538,8 +2540,6 @@ void SPI_scroll_cursor_move(Portal portal, FetchDirection close a cursor - SPI_cursor_close - void SPI_cursor_close(Portal portal) @@ -2580,6 +2580,8 @@ void SPI_cursor_close(Portal portal) + SPI_keepplan + SPI_keepplan 3 @@ -2590,8 +2592,6 @@ void SPI_cursor_close(Portal portal) save a prepared statement - SPI_keepplan - int SPI_keepplan(SPIPlanPtr plan) @@ -2649,6 +2649,8 @@ int SPI_keepplan(SPIPlanPtr plan) + SPI_saveplan + SPI_saveplan 3 @@ -2659,8 +2661,6 @@ int SPI_keepplan(SPIPlanPtr plan) save a prepared statement - SPI_saveplan - SPIPlanPtr SPI_saveplan(SPIPlanPtr plan) @@ -2760,6 +2760,8 @@ SPIPlanPtr SPI_saveplan(SPIPlanPtr plan) + SPI_fname + SPI_fname 3 @@ -2770,8 +2772,6 @@ SPIPlanPtr SPI_saveplan(SPIPlanPtr plan) determine the column name for the specified column number - SPI_fname - char * SPI_fname(TupleDesc rowdesc, int colnumber) @@ -2827,6 +2827,8 @@ char * SPI_fname(TupleDesc rowdesc, int colnum + SPI_fnumber + SPI_fnumber 3 @@ -2837,8 +2839,6 @@ char * SPI_fname(TupleDesc rowdesc, int colnum determine the column number for the specified column name - SPI_fnumber - int SPI_fnumber(TupleDesc rowdesc, const char * colname) @@ -2901,6 +2901,8 @@ int SPI_fnumber(TupleDesc rowdesc, const char * + SPI_getvalue + SPI_getvalue 3 @@ -2911,8 +2913,6 @@ int SPI_fnumber(TupleDesc rowdesc, const char * return the string value of the specified column - SPI_getvalue - char * SPI_getvalue(HeapTuple row, TupleDesc rowdesc, int colnumber) @@ -2985,6 +2985,8 @@ char * SPI_getvalue(HeapTuple row, TupleDesc r + SPI_getbinval + SPI_getbinval 3 @@ -2995,8 +2997,6 @@ char * SPI_getvalue(HeapTuple row, TupleDesc r return the binary value of the specified column - SPI_getbinval - Datum SPI_getbinval(HeapTuple row, TupleDesc rowdesc, int colnumber, @@ -3080,6 +3080,8 @@ Datum SPI_getbinval(HeapTuple row, TupleDesc r + SPI_gettype + SPI_gettype 3 @@ -3090,8 +3092,6 @@ Datum SPI_getbinval(HeapTuple row, TupleDesc r return the data type name of the specified column - SPI_gettype - char * SPI_gettype(TupleDesc rowdesc, int colnumber) @@ -3146,6 +3146,8 @@ char * SPI_gettype(TupleDesc rowdesc, int coln + SPI_gettypeid + SPI_gettypeid 3 @@ -3156,8 +3158,6 @@ char * SPI_gettype(TupleDesc rowdesc, int coln return the data type OID of the specified column - SPI_gettypeid - Oid SPI_gettypeid(TupleDesc rowdesc, int colnumber) @@ -3212,6 +3212,8 @@ Oid SPI_gettypeid(TupleDesc rowdesc, int colnu + SPI_getrelname + SPI_getrelname 3 @@ -3222,8 +3224,6 @@ Oid SPI_gettypeid(TupleDesc rowdesc, int colnu return the name of the specified relation - SPI_getrelname - char * SPI_getrelname(Relation rel) @@ -3265,6 +3265,8 @@ char * SPI_getrelname(Relation rel) + SPI_getnspname + SPI_getnspname 3 @@ -3275,8 +3277,6 @@ char * SPI_getrelname(Relation rel) return the namespace of the specified relation - SPI_getnspname - char * SPI_getnspname(Relation rel) @@ -3400,6 +3400,8 @@ char * SPI_getnspname(Relation rel) + SPI_palloc + SPI_palloc 3 @@ -3410,8 +3412,6 @@ char * SPI_getnspname(Relation rel) allocate memory in the upper executor context - SPI_palloc - void * SPI_palloc(Size size) @@ -3454,6 +3454,8 @@ void * SPI_palloc(Size size) + SPI_repalloc + SPI_repalloc 3 @@ -3464,8 +3466,6 @@ void * SPI_palloc(Size size) reallocate memory in the upper executor context - SPI_repalloc - void * SPI_repalloc(void * pointer, Size size) @@ -3524,6 +3524,8 @@ void * SPI_repalloc(void * pointer, Size size< + SPI_pfree + SPI_pfree 3 @@ -3534,8 +3536,6 @@ void * SPI_repalloc(void * pointer, Size size< free memory in the upper executor context - SPI_pfree - void SPI_pfree(void * pointer) @@ -3577,6 +3577,8 @@ void SPI_pfree(void * pointer) + SPI_copytuple + SPI_copytuple 3 @@ -3587,8 +3589,6 @@ void SPI_pfree(void * pointer) make a copy of a row in the upper executor context - SPI_copytuple - HeapTuple SPI_copytuple(HeapTuple row) @@ -3634,6 +3634,8 @@ HeapTuple SPI_copytuple(HeapTuple row) + SPI_returntuple + SPI_returntuple 3 @@ -3644,8 +3646,6 @@ HeapTuple SPI_copytuple(HeapTuple row) prepare to return a tuple as a Datum - SPI_returntuple - HeapTupleHeader SPI_returntuple(HeapTuple row, TupleDesc rowdesc) @@ -3709,6 +3709,8 @@ HeapTupleHeader SPI_returntuple(HeapTuple row, TupleDesc + SPI_modifytuple + SPI_modifytuple 3 @@ -3719,8 +3721,6 @@ HeapTupleHeader SPI_returntuple(HeapTuple row, TupleDesc create a row by replacing selected fields of a given row - SPI_modifytuple - HeapTuple SPI_modifytuple(Relation rel, HeapTuple row, int ncols, @@ -3857,6 +3857,8 @@ HeapTuple SPI_modifytuple(Relation rel, HeapTuple + SPI_freetuple + SPI_freetuple 3 @@ -3867,8 +3869,6 @@ HeapTuple SPI_modifytuple(Relation rel, HeapTuple free a row allocated in the upper executor context - SPI_freetuple - void SPI_freetuple(HeapTuple row) @@ -3909,6 +3909,8 @@ void SPI_freetuple(HeapTuple row) + SPI_freetuptable + SPI_freetuptable 3 @@ -3920,8 +3922,6 @@ void SPI_freetuple(HeapTuple row) function - SPI_freetuptable - void SPI_freetuptable(SPITupleTable * tuptable) @@ -3976,6 +3976,8 @@ void SPI_freetuptable(SPITupleTable * tuptable) + SPI_freeplan + SPI_freeplan 3 @@ -3986,8 +3988,6 @@ void SPI_freetuptable(SPITupleTable * tuptable) free a previously saved prepared statement - SPI_freeplan - int SPI_freeplan(SPIPlanPtr plan) diff --git a/doc/src/sgml/vacuumlo.sgml b/doc/src/sgml/vacuumlo.sgml index b9629bf2f5..9da61c93fe 100644 --- a/doc/src/sgml/vacuumlo.sgml +++ b/doc/src/sgml/vacuumlo.sgml @@ -1,6 +1,10 @@ + + vacuumlo + + vacuumlo 1 @@ -12,10 +16,6 @@ remove orphaned large objects from a PostgreSQL database - - vacuumlo - - vacuumlo -- 2.40.0