Search PostgreSQL documentation

dropdb --versionCommand-line ToolsPG18-V--version Print the dropdb version and exit.dropdb › Options Dropping RolesManual ChaptersPG1821.4. Dropping Roles Because roles can own database objects and can hold privileges to access other objects, dropping a role is often not just a matter of a quick DROP ROLE. Any objects owne…Dropping Roles dropuserCommand-line ToolsPG18dropuser dropuser — remove a PostgreSQL user account Synopsis dropuser [connection-option...] [option...] [username]dropuser dropuserManual ChaptersPG18dropuser dropuser — remove a PostgreSQL user account Synopsis dropuser [connection-option...] [option...] [username]dropuser dropuser --echoCommand-line ToolsPG18-e--echo Echo the commands that dropuser generates and sends to the server.dropuser › Options dropuser --helpCommand-line ToolsPG18-?--help Show help about dropuser command line arguments, and exit.dropuser › Options dropuser --host=hostCommand-line ToolsPG18-h host--host=host Specifies the host name of the machine on which the server is running. If the value begins with a slash, it is used as the directory for the Unix domain socket.dropuser › Options dropuser --if-existsCommand-line ToolsPG18--if-exists Do not throw an error if the user does not exist. A notice is issued in this case.dropuser › Options dropuser --interactiveCommand-line ToolsPG18-i--interactive Prompt for confirmation before actually removing the user, and prompt for the user name if none is specified on the command line.dropuser › Options dropuser --no-passwordCommand-line ToolsPG18-w--no-password Never issue a password prompt. If the server requires password authentication and a password is not available by other means such as a .pgpass file, the connection attempt wi…dropuser › Options dropuser --passwordCommand-line ToolsPG18-W--password Force dropuser to prompt for a password before connecting to a database. This option is never essential, since dropuser will automatically prompt for a password if the server de…dropuser › Options dropuser --port=portCommand-line ToolsPG18-p port--port=port Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections.dropuser › Options dropuser --username=usernameCommand-line ToolsPG18-U username--username=username User name to connect as (not the user name to drop).dropuser › Options dropuser --versionCommand-line ToolsPG18-V--version Print the dropuser version and exit.dropuser › Options dsefExtensionsExtensionsDiffStats and ExplainFull: detailed SQL reports for third party help & support explain performance plan sql statistics stats dsef MonitoringMonitoring · Extensions DsmAllocateWait EventsReferenceDsmAllocate IO 16 Waiting for a dynamic shared memory segment to be allocated. 17 18 19 20 The wait is normal when the workload is expected to perform this read, write, sync, allocation, or …Wait Events · IO DsmFillZeroWriteWait EventsReferenceDsmFillZeroWrite IO 10 Waiting to write zero bytes to a dynamic shared memory backing file. 11 12 13 Waiting to fill a dynamic shared memory backing file with zeroes. 14 15 16 17 18 19 20 Th…Wait Events · IO DSMRegistryWait EventsReferenceDSMRegistry LWLock 17 Waiting to read or update the dynamic shared memory registry. 18 19 20 A brief sample is normal around short internal critical sections. Investigate when the same tranc…Wait Events · LWLock DSMRegistryDSAWait EventsReferenceDSMRegistryDSA LWLock 17 Waiting to access dynamic shared memory registry's dynamic shared memory allocator. 18 19 20 A brief sample is normal around short internal critical sections. Invest…Wait Events · LWLock DSMRegistryHashWait EventsReferenceDSMRegistryHash LWLock 17 Waiting to access dynamic shared memory registry's shared hash table. 18 19 20 A brief sample is normal around short internal critical sections. Investigate when th…Wait Events · LWLock duckdb_fdwExtensionsExtensionsDuckDB Foreign Data Wrapper duckdb duckdb_fdw AnalyticsAnalytics · Extensions dummy_dataExtensionsExtensionsReadable, Null Foreign Data Wrapper for Postgresql 9.3+ dummy_data Foreign data wrappersForeign data wrappers · Extensions dummy_index_amExtensionsExtensionsMinimal dummy index access method for testing PostgreSQL index-AM facilities. dummy_index_am FeaturesFeatures · Extensions dump_fcinfoExtensionsExtensionsDumps the PostgreSQL fcinfo and rsinfo c debug debugging debugging-tool devtools postgresql postgresql-extension dump_fcinfo UtilitiesUtilities · Extensions dump_fdwExtensionsExtensionsForeign data wrapper for querying rows directly from PostgreSQL custom-format dump files backup fdw pg-dump dump_fdw Foreign data wrappersForeign data wrappers · Extensions dumppointsExtensionsExtensionsC implementation of ST_DumpPoints for PostGIS geometry collections. geometry postgis st-dumppoints dumppoints GeospatialGeospatial · Extensions dventimi@pg_flight_recorderExtensionsExtensionsServer-side flight recorder for PostgreSQL performance monitoring database.dev tle dventimi@pg_flight_recorder MonitoringMonitoring · Extensions dventimi@pg_flight_recorder_controlExtensionsExtensionsControl functions for pg_flight_recorder database.dev tle dventimi@pg_flight_recorder_control MonitoringMonitoring · Extensions dventimi@pg_flight_recorder_reportingExtensionsExtensionsReporting and analysis functions for pg_flight_recorder database.dev tle dventimi@pg_flight_recorder_reporting MonitoringMonitoring · Extensions dventimi@pg_partition_magicianExtensionsExtensionsPure-SQL online RANGE partition manager for time, numeric, UUIDv7, and encoded text keys database.dev tle partitioning dventimi@pg_partition_magician AnalyticsAnalytics · Extensions Dynamic Domain TransitionsManual ChaptersPG18F.40.5.5. Dynamic Domain Transitions It is possible to use SELinux's dynamic domain transition feature to switch the security label of the client process, the client domain, to a new context…Dynamic Domain Transitions Dynamic LoadingManual ChaptersPG1836.10.1. Dynamic Loading The first time a user-defined function in a particular loadable object file is called in a session, the dynamic loader loads that object file into memory so that the…Dynamic Loading Dynamic SQLManual ChaptersPG1834.5. Dynamic SQL In many cases, the particular SQL statements that an application has to execute are known at the time the application is written. In some cases, however, the SQL statements…Dynamic SQL Dynamic TracingManual ChaptersPG1827.5. Dynamic Tracing PostgreSQL provides facilities to support dynamic tracing of the database server. This allows an external utility to be called at specific points in the code and thereb…Dynamic Tracing dynamic_library_pathConfigurationReferencedynamic_library_path Client Connection Defaults 10 If a dynamically loadable module needs to be opened and the file name specified in the CREATE FUNCTION or LOAD command does not have a dire…Configuration · Client Connection Defaults dynamic_shared_memory_typeConfigurationReferencedynamic_shared_memory_type Resource Usage 10 Specifies the dynamic shared memory implementation that the server should use. Possible values are posix (for POSIX shared memory allocated using…Configuration · Resource Usage DynamicSharedMemoryControlWait EventsReferenceDynamicSharedMemoryControl LWLock 10 Waiting to read or update dynamic shared memory state. 11 12 13 Waiting to read or update dynamic shared memory allocation information. 14 15 16 17 18 19…Wait Events · LWLock dynamodb_fdwExtensionsExtensionsForeign data wrapper for querying and modifying Amazon DynamoDB tables from PostgreSQL. aws dynamodb fdw dynamodb_fdw Foreign data wrappersForeign data wrappers · Extensions eachFunctionsPG18each ( hstore ) → setof record ( key text, value text ) Extracts an hstore's keys and values as a set of records. select * from each('a=>1,b=>2') → key | value -----+------- a | 1 b | 2hstore — hstore key/value datatype › hstore Operators and Functions eaggrExtensionsExtensionsThe OpenEAGGR software library is an implementation of a Discrete Global Grid System (DGGS) which models the Earth's surface as a network of equal area cells. eaggr GeospatialGeospatial · Extensions