Server Configuration: Client Connection Defaults
  • References/Database/PostgreSQL/Server Configuration

19.11.1. Statement Behavior search_path (string)

2025-01-10 15:47:30
Updating Data
  • References/Database/PostgreSQL/Data Manipulation

The modification of data that is already in the database is referred to as updating. You can update individual rows, all the rows in a table, or a subset of all rows. Each

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

This module implements a data type ltree for representing labels of data stored in a hierarchical tree-like structure. Extensive facilities for searching

2025-01-10 15:47:30
Transaction Isolation
  • References/Database/PostgreSQL/Concurrency Control

The SQL standard defines four levels of transaction isolation. The most strict is Serializable, which is defined by the standard in a paragraph

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

The postgres_fdw module provides the foreign-data wrapper postgres_fdw, which can be used to access data stored in

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

PostgreSQL provides two data types that are designed to support full text search, which is the activity of searching through a collection of

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

NameDROP SEQUENCE -- remove a sequence Synopsis

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

The view pg_timezone_abbrevs provides a list of time zone abbreviations that are currently recognized by the datetime input routines. The contents

2025-01-10 15:47:30
Full Text Search
  • References/Database/PostgreSQL/Full Text Search

Full Text Searching (or just text search) provides the capability to identify natural-language documents that satisfy a

2025-01-10 15:47:30
Dependency Tracking
  • References/Database/PostgreSQL/Data Definition

When you create complex database structures involving many tables with foreign key constraints, views, triggers, functions, etc. you implicitly create a net of dependencies

2025-01-10 15:47:30