3.
  • References/Database/PostgreSQL/Tutorial/Getting Started

The first test to see whether you can access the database server is to try to create a database. A running PostgreSQL server can manage many

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
CREATE TRANSFORM
  • References/Database/PostgreSQL/Commands

NameCREATE TRANSFORM -- define a new transform Synopsis

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

Bit strings are strings of 1's and 0's. They can be used to store or visualize bit masks. There are two SQL bit types: bit(n)

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

The pg_available_extension_versions view lists the specific extension versions that are available for installation. See also the

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

The sslinfo module provides information about the SSL certificate that the current client provided when connecting to

2025-01-10 15:47:30
Internals: PostgreSQL Rule System
  • References/Database/PostgreSQL/Internals

PostgreSQL supports a powerful rule system for the specification of views and ambiguous

2025-01-10 15:47:30
SET SESSION AUTHORIZATION
  • References/Database/PostgreSQL/Commands

NameSET SESSION AUTHORIZATION -- set the session user identifier and the current user identifier of the current session

2025-01-10 15:47:30
Preventing Server Spoofing
  • References/Database/PostgreSQL/Server Setup and Operation

While the server is running, it is not possible for a malicious user to take the place of the normal database server. However, when the server is down, it is possible for a

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

This section describes functions that possibly return more than one row. The most widely used functions in this class are series generating functions, as detailed in Table

2025-01-10 15:47:30