Server Configuration: File Locations
  • References/Database/PostgreSQL/Server Configuration

In addition to the postgresql.conf file already mentioned, PostgreSQL uses two other manually-edited configuration

2025-01-10 15:47:30
Default Roles
  • References/Database/PostgreSQL/Database Roles

PostgreSQL provides a set of default roles which provide access to certain, commonly needed, privileged capabilities and information. Administrators

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

NameVALUES -- compute a set of rows Synopsis

2025-01-10 15:47:30
Table Expressions
  • References/Database/PostgreSQL/Queries

A table expression computes a table. The table expression contains a FROM clause that is optionally followed by

2025-01-10 15:47:30
Internals//GIN Indexes: Examples
  • References/Database/PostgreSQL/Internals/GIN Indexes

The PostgreSQL source distribution includes GIN operator classes for tsvector

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

The intagg module provides an integer aggregator and an enumerator. intagg is now obsolete, because there are built-in

2025-01-10 15:47:30
Upgrading a PostgreSQL Cluster
  • References/Database/PostgreSQL/Server Setup and Operation

This section discusses how to upgrade your database data from one PostgreSQL release to a newer one.

2025-01-10 15:47:30
Catalogs: pg_ts_config
  • References/Database/PostgreSQL/Internals: Catalogs

The pg_ts_config catalog contains entries representing text search configurations. A configuration specifies a particular text search parser

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

NameEXPLAIN -- show the execution plan of a statement Synopsis

2025-01-10 15:47:30
Monetary Types
  • References/Database/PostgreSQL/Data Types

The money type stores a currency amount with a fixed fractional precision; see Table 8-3. The fractional precision is determined by the database's

2025-01-10 15:47:30