From 5bcf8ede45c780e4ac394397bd0413118f3a162f Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Fri, 9 Dec 2011 20:42:30 +0200 Subject: Add ALTER FOREIGN DATA WRAPPER / RENAME and ALTER SERVER / RENAME --- doc/src/sgml/ref/alter_foreign_data_wrapper.sgml | 22 +++++++++++++++++++++- doc/src/sgml/ref/alter_server.sgml | 21 +++++++++++++++++++++ 2 files changed, 42 insertions(+), 1 deletion(-) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml b/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml index 59cf9c65e77..7376804403d 100644 --- a/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml +++ b/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml @@ -26,6 +26,7 @@ ALTER FOREIGN DATA WRAPPER name [ VALIDATOR validator_function | NO VALIDATOR ] [ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ]) ] ALTER FOREIGN DATA WRAPPER name OWNER TO new_owner +ALTER FOREIGN DATA WRAPPER name RENAME TO new_name @@ -122,6 +123,24 @@ ALTER FOREIGN DATA WRAPPER name OWN + + + new_owner + + + The user name of the new owner of the foreign-data wrapper. + + + + + + new_name + + + The new name for the foreign-data wrapper. + + + @@ -150,7 +169,8 @@ ALTER FOREIGN DATA WRAPPER dbi VALIDATOR bob.myvalidator; ALTER FOREIGN DATA WRAPPER conforms to ISO/IEC 9075-9 (SQL/MED), except that the HANDLER, - VALIDATOR and OWNER TO clauses are extensions. + VALIDATOR, OWNER TO, and RENAME + clauses are extensions. diff --git a/doc/src/sgml/ref/alter_server.sgml b/doc/src/sgml/ref/alter_server.sgml index c27b4c06a1c..248efd91630 100644 --- a/doc/src/sgml/ref/alter_server.sgml +++ b/doc/src/sgml/ref/alter_server.sgml @@ -24,6 +24,7 @@ PostgreSQL documentation ALTER SERVER server_name [ VERSION 'new_version' ] [ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) ] ALTER SERVER server_name OWNER TO new_owner +ALTER SERVER server_name RENAME TO new_name @@ -82,6 +83,24 @@ ALTER SERVER server_name OWNER TO < + + + new_owner + + + The user name of the new owner of the foreign server. + + + + + + new_name + + + The new name for the foreign server. + + + @@ -108,6 +127,8 @@ ALTER SERVER foo VERSION '8.4' OPTIONS (SET host 'baz'); ALTER SERVER conforms to ISO/IEC 9075-9 (SQL/MED). + The OWNER TO and RENAME forms are + PostgreSQL extensions. -- cgit v1.2.3