Administration Functions
  • References/Database/PostgreSQL/Functions/System Administration

The functions described in this section are used to control and monitor a PostgreSQL installation.

2025-01-10 15:47:30
DROP ROLE
  • References/Database/PostgreSQL/Commands

NameDROP ROLE -- remove a database role Synopsis

2025-01-10 15:47:30
ALTER SCHEMA
  • References/Database/PostgreSQL/Commands

NameALTER SCHEMA -- change the definition of a schema Synopsis

2025-01-10 15:47:30
7.
  • References/Database/PostgreSQL/Tutorial/Advanced Features

PostgreSQL has many features not touched upon in this tutorial introduction, which has been oriented toward newer users of

2025-01-10 15:47:30
pg_trgm
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

The pg_trgm module provides functions and operators for determining the similarity of alphanumeric text based on trigram matching, as well as

2025-01-10 15:47:30
Server Configuration: Query Planning
  • References/Database/PostgreSQL/Server Configuration

19.7.1. Planner Method Configuration These configuration parameters provide a crude method of influencing the query plans chosen

2025-01-10 15:47:30
DROP ACCESS METHOD
  • References/Database/PostgreSQL/Commands

NameDROP ACCESS METHOD -- remove an access method Synopsis

2025-01-10 15:47:30
DROP OWNED
  • References/Database/PostgreSQL/Commands

NameDROP OWNED -- remove database objects owned by a database role Synopsis

2025-01-10 15:47:30
DISCARD
  • References/Database/PostgreSQL/Commands

NameDISCARD -- discard session state Synopsis

2025-01-10 15:47:30
WAL Configuration
  • References/Database/PostgreSQL/Write-Ahead Log

There are several WAL-related configuration parameters that affect database performance. This section explains their use. Consult Chapter

2025-01-10 15:47:30