Schemas
  • References/Database/PostgreSQL/Data Definition

A PostgreSQL database cluster contains one or more named databases. Users and groups of users are shared across the entire cluster, but no

2025-01-10 15:47:30
Array Functions and Operators
  • References/Database/PostgreSQL/Functions/Array

Table 9-47 shows the operators available for array types. Table 9-47. Array Operators

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

Object identifiers (OIDs) are used internally by PostgreSQL as primary keys for various system tables. OIDs are not added to user-created tables

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

The catalog pg_foreign_server stores foreign server definitions. A foreign server describes a source of external data, such as a remote server

2025-01-10 15:47:30
Error Message Style Guide
  • References/Database/PostgreSQL/PostgreSQL Coding Conventions

This style guide is offered in the hope of maintaining a consistent, user-friendly style throughout all the messages generated by PostgreSQL

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

dict_xsyn (Extended Synonym Dictionary) is an example of an add-on dictionary template for full-text search. This dictionary type replaces words

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

The file_fdw module provides the foreign-data wrapper file_fdw, which can be used to access data files in the server's

2025-01-10 15:47:30
pg_dump
  • References/Database/PostgreSQL/Applications

Namepg_dump -- extract a PostgreSQL database into a script file or other archive file

2025-01-10 15:47:30
Internals: Row Estimation Examples
  • References/Database/PostgreSQL/Internals

The examples shown below use tables in the PostgreSQL regression test database. The outputs shown are taken from version 8.3. The behavior

2025-01-10 15:47:30
pg_rewind
  • References/Database/PostgreSQL/Applications

Namepg_rewind -- synchronize a PostgreSQL data directory with another data directory that was forked from it

2025-01-10 15:47:30