NameDROP USER -- remove a database role Synopsis DROP USER [ IF EXISTS ] name [, ...] Description DROP USER is simply an alternate spelling of DROP ROLE. Compatibility The DROP USER statement is a PostgreSQL extension. The SQL standard leaves the definition of users to the implementation. See Also DROP ROLE Prev Next DROP TYPE Up DROP USER MAPPING

NameDROP VIEW -- remove a view Synopsis DROP VIEW [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] Description DROP VIEW drops an existing view. To execute this command you must be the owner of the view. Parameters IF EXISTS Do not throw an error if the view does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of the view to remove. CASCADE Automatically drop objects that depend on the view (such as other views), and in turn all object

Before we proceed, you should understand the basic PostgreSQL system architecture. Understanding how the parts of PostgreSQL interact will make this chapter somewhat clearer. In database jargon, PostgreSQL uses a client/server model. A PostgreSQL session consists of the following cooperating processes (programs): A server process, which manages the database files, accepts connections to the database from client applications, and performs database actions on behalf of the clients. The database

NameDROP TEXT SEARCH TEMPLATE -- remove a text search template Synopsis DROP TEXT SEARCH TEMPLATE [ IF EXISTS ] name [ CASCADE | RESTRICT ] Description DROP TEXT SEARCH TEMPLATE drops an existing text search template. You must be a superuser to use this command. Parameters IF EXISTS Do not throw an error if the text search template does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of an existing text search template. CASCADE Automati

The view pg_config describes the compile-time configuration parameters of the currently installed version of PostgreSQL. It is intended, for example, to be used by software packages that want to interface to PostgreSQL to facilitate finding the required header files and libraries. It provides the same basic information as the pg_config PostgreSQL client application. By default, the pg_config view can be read only by superusers. Table 50-61. pg_config Columns Name Type Description name text Th

NameDROP SERVER -- remove a foreign server descriptor Synopsis DROP SERVER [ IF EXISTS ] name [ CASCADE | RESTRICT ] Description DROP SERVER removes an existing foreign server descriptor. To execute this command, the current user must be the owner of the server. Parameters IF EXISTS Do not throw an error if the server does not exist. A notice is issued in this case. name The name of an existing server. CASCADE Automatically drop objects that depend on the server (such as user

Namecreatedb -- create a new PostgreSQL database Synopsis createdb [connection-option...] [option...] [dbname [description]] Description createdb creates a new PostgreSQL database. Normally, the database user who executes this command becomes the owner of the new database. However, a different owner can be specified via the -O option, if the executing user has appropriate privileges. createdb is a wrapper around the SQL command CREATE DATABASE. There is no effective difference between c

In some situations it is worthwhile to rebuild indexes periodically with the REINDEX command or a series of individual rebuilding steps. B-tree index pages that have become completely empty are reclaimed for re-use. However, there is still a possibility of inefficient use of space: if all but a few index keys on a page have been deleted, the page remains allocated. Therefore, a usage pattern in which most, but not all, keys in each range are eventually deleted will see poor use of space. For su

NameDROP TEXT SEARCH CONFIGURATION -- remove a text search configuration Synopsis DROP TEXT SEARCH CONFIGURATION [ IF EXISTS ] name [ CASCADE | RESTRICT ] Description DROP TEXT SEARCH CONFIGURATION drops an existing text search configuration. To execute this command you must be the owner of the configuration. Parameters IF EXISTS Do not throw an error if the text search configuration does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of

NameALTER USER MAPPING -- change the definition of a user mapping Synopsis ALTER USER MAPPING FOR { user_name | USER | CURRENT_USER | SESSION_USER | PUBLIC } SERVER server_name OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) Description ALTER USER MAPPING changes the definition of a user mapping. The owner of a foreign server can alter user mappings for that server for any user. Also, a user can alter a user mapping for their own user name if USAGE privilege on the