DeviceKit-power – System-wide Power Management Description DeviceKit-power provides an interface to enumerate power sources on the system and control system-wide power management. Any application can access the org.freedesktop.DeviceKit.Power service on the system message bus. Some operations (such as suspending the system) is restricted using PolicyKit. Author Written by David Zeuthen davidz [at] redhat.com with a…
DeviceKit-disks – Disk Management Description DeviceKit-disks provides an interface to enumerate block devices and perform operations on them. Any application can access the org.freedesktop.DeviceKit.Disks service on the system message bus. Some operations (such as formatting disks etc.) is restricted using PolicyKit. Device Information On Linux, DeviceKit-disks relies on recent versions of udev(7) and the kernel….
DROP 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…
DROP USER MAPPING – remove a user mapping for a foreign server Synopsis DROP USER MAPPING [ IF EXISTS ] FOR { username | USER | CURRENT_USER | PUBLIC } SERVER servername Description DROP USER MAPPING removes an existing user mapping from foreign server. The owner of a foreign server can drop user mappings for…
DROP_USER – remove a database role Synopsis DROP USER [ IF EXISTS ] name [, …] Description DROP USER is simply an alternate spelling of DROP ROLE (DROP_ROLE(7)). Compatibility The DROP USER statement is a PostgreSQL extension. The SQL standard leaves the definition of users to the implementation. See Also DROP ROLE (DROP_ROLE(7))
DROP TYPE – remove a data type Synopsis DROP TYPE [ IF EXISTS ] name [, …] [ CASCADE | RESTRICT ] Description DROP TYPE removes a user-defined data type. Only the owner of a type can remove it. Parameters IF EXISTS Do not throw an error if the type does not exist. A notice…
DROP TRIGGER – remove a trigger Synopsis DROP TRIGGER [ IF EXISTS ] name ON table [ CASCADE | RESTRICT ] Description DROP TRIGGER removes an existing trigger definition. To execute this command, the current user must be the owner of the table for which the trigger is defined. Parameters IF EXISTS Do not throw…
DROP 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…
DROP TEXT SEARCH PARSER – remove a text search parser Synopsis DROP TEXT SEARCH PARSER [ IF EXISTS ] name [ CASCADE | RESTRICT ] Description DROP TEXT SEARCH PARSER drops an existing text search parser. You must be a superuser to use this command. Parameters IF EXISTS Do not throw an error if the…
DROP TEXT SEARCH DICTIONARY – remove a text search dictionary Synopsis DROP TEXT SEARCH DICTIONARY [ IF EXISTS ] name [ CASCADE | RESTRICT ] Description DROP TEXT SEARCH DICTIONARY drops an existing text search dictionary. To execute this command you must be the owner of the dictionary. Parameters IF EXISTS Do not throw an…
DROP 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…
DROP TABLESPACE – remove a tablespace Synopsis DROP TABLESPACE [ IF EXISTS ] tablespacename Description DROP TABLESPACE removes a tablespace from the system. A tablespace can only be dropped by its owner or a superuser. The tablespace must be empty of all database objects before it can be dropped. It is possible that objects in…
DROP TABLE – remove a table Synopsis DROP TABLE [ IF EXISTS ] name [, …] [ CASCADE | RESTRICT ] Description DROP TABLE removes tables from the database. Only its owner can drop a table. To empty a table of rows without destroying the table, use DELETE [delete(7)] or TRUNCATE [truncate(7)]. DROP TABLE always…
DROP SERVER – remove a foreign server descriptor Synopsis DROP SERVER [ IF EXISTS ] servername [ 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…
DROP SEQUENCE – remove a sequence Synopsis DROP SEQUENCE [ IF EXISTS ] name [, …] [ CASCADE | RESTRICT ] Description DROP SEQUENCE removes sequence number generators. A sequence can only be dropped by its owner or a superuser. Parameters IF EXISTS Do not throw an error if the sequence does not exist. A…
DROP SCHEMA – remove a schema Synopsis DROP SCHEMA [ IF EXISTS ] name [, …] [ CASCADE | RESTRICT ] Description DROP SCHEMA removes schemas from the database. A schema can only be dropped by its owner or a superuser. Note that the owner can drop the schema (and thereby all contained objects) even…
DROP RULE – remove a rewrite rule Synopsis DROP RULE [ IF EXISTS ] name ON relation [ CASCADE | RESTRICT ] Description DROP RULE drops a rewrite rule. Parameters IF EXISTS Do not throw an error if the rule does not exist. A notice is issued in this case. name The name of the…
DROP ROLE – remove a database role Synopsis DROP ROLE [ IF EXISTS ] name [, …] Description DROP ROLE removes the specified role(s). To drop a superuser role, you must be a superuser yourself; to drop non-superuser roles, you must have CREATEROLE privilege. A role cannot be removed if it is still referenced in…
DROP OWNED – remove database objects owned by a database role Synopsis DROP OWNED BY name [, …] [ CASCADE | RESTRICT ] Description DROP OWNED drops all the objects in the current database that are owned by one of the specified roles. Any privileges granted to the given roles on objects in the current…
DROP OPERATOR FAMILY – remove an operator family Synopsis DROP OPERATOR FAMILY [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ] Description DROP OPERATOR FAMILY drops an existing operator family. To execute this command you must be the owner of the operator family. DROP OPERATOR FAMILY includes dropping any operator classes contained…