...TABLESPACE cannot be executed inside a transaction block. EXAMPLES To create a tablespace dbspace at file system location /data/dbs, first create the directory using operating s…...names and values are dependent on the server's foreign-data wrapper. NOTES When using the dblink module, a foreign server's name can be used as an argument of the dblink_connect…...as ALTER PROCEDURE and COMMENT ON PROCEDURE . EXAMPLES If there is only one procedure do_db_maintenance, this command is sufficient to drop it: DROP PROCEDURE do_db_maintenance;…...ew_name The new name for the foreign-data wrapper. EXAMPLES Change a foreign-data wrapper dbi, add option foo, drop bar: ALTER FOREIGN DATA WRAPPER dbi OPTIONS (ADD foo '1', DRO…...if any objects depend on it. This is the default. EXAMPLES Drop the foreign-data wrapper dbi: DROP FOREIGN DATA WRAPPER dbi; COMPATIBILITY DROP FOREIGN DATA WRAPPER conforms to …...dles output parameters in CALL commands differently; see Section 41.6.3. EXAMPLES CALL do_db_maintenance(); COMPATIBILITY CALL conforms to the SQL standard, except for the handl…...ce both CREATE USER MAPPING and DROP USER MAPPING use FOR in analogous positions, and IBM DB2 (being the other major SQL/MED implementation) also requires it for ALTER USER MAPP…...ATTERN), ~DReplaces:PATTERN, ?obsoletes(PATTERN), ~DObsoletes:PATTERN, ?breaks(PATTERN), ~DBreaks:PATTERN, ?enhances(PATTERN), ~DEnhances:PATTERN Selects versions depending/pre-…...ut trusting the system indexes to be valid already: $ export PGOPTIONS="-P" $ psql broken_db ... broken_db=> REINDEX DATABASE broken_db; broken_db=> \q Rebuild indexes for a tab…...s: asctime() basename() catgets() crypt() ctermid() if passed a non-NULL argument ctime() dbm_clearerr() dbm_close() dbm_delete() dbm_error() dbm_fetch() dbm_firstkey() dbm_next…...EXAMPLES Alter server foo, add connection options: ALTER SERVER foo OPTIONS (host 'foo', dbname 'foodb'); Alter server foo, change version, change host option: ALTER SERVER foo …...EN 331 217 D9 մ ARMENIAN SMALL LETTER MEN 332 218 DA Յ ARMENIAN CAPITAL LETTER YI 333 219 DB յ ARMENIAN SMALL LETTER YI 334 220 DC Ն ARMENIAN CAPITAL LETTER NOW 335 221 DD ն ARM…...GREEK CAPITAL LETTER OMEGA 332 218 DA Ϊ GREEK CAPITAL LETTER IOTA WITH DIALYTIKA 333 219 DB Ϋ GREEK CAPITAL LETTER UPSILON WITH DIALYTIKA 334 220 DC ά GREEK SMALL LETTER ALPHA W…...331 217 D9 й CYRILLIC SMALL LETTER SHORT I 332 218 DA к CYRILLIC SMALL LETTER KA 333 219 DB л CYRILLIC SMALL LETTER EL 334 220 DC м CYRILLIC SMALL LETTER EM 335 221 DD н CYRILLI…...GREEK CAPITAL LETTER OMEGA 332 218 DA Ϊ GREEK CAPITAL LETTER IOTA WITH DIALYTIKA 333 219 DB Ϋ GREEK CAPITAL LETTER UPSILON WITH DIALYTIKA 334 220 DC ά GREEK SMALL LETTER ALPHA W…...331 217 D9 й CYRILLIC SMALL LETTER SHORT I 332 218 DA к CYRILLIC SMALL LETTER KA 333 219 DB л CYRILLIC SMALL LETTER EL 334 220 DC м CYRILLIC SMALL LETTER EM 335 221 DD н CYRILLI…...GREEK CAPITAL LETTER OMEGA 332 218 DA Ϊ GREEK CAPITAL LETTER IOTA WITH DIALYTIKA 333 219 DB Ϋ GREEK CAPITAL LETTER UPSILON WITH DIALYTIKA 334 220 DC ά GREEK SMALL LETTER ALPHA W…...331 217 D9 й CYRILLIC SMALL LETTER SHORT I 332 218 DA к CYRILLIC SMALL LETTER KA 333 219 DB л CYRILLIC SMALL LETTER EL 334 220 DC м CYRILLIC SMALL LETTER EM 335 221 DD н CYRILLI…...LATIN CAPITAL LETTER U WITH GRAVE 332 218 DA Ú LATIN CAPITAL LETTER U WITH ACUTE 333 219 DB Û LATIN CAPITAL LETTER U WITH CIRCUMFLEX 334 220 DC Ü LATIN CAPITAL LETTER U WITH DIA…...LATIN CAPITAL LETTER L WITH STROKE 332 218 DA Ś LATIN CAPITAL LETTER S WITH ACUTE 333 219 DB Ū LATIN CAPITAL LETTER U WITH MACRON 334 220 DC Ü LATIN CAPITAL LETTER U WITH DIAERE…