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
droplang
  • References/Database/PostgreSQL/Applications

Namedroplang -- remove a PostgreSQL procedural language

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

The catalog pg_largeobject_metadata holds metadata associated with large objects. The actual large object data is stored in

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

The view pg_policies provides access to useful information about each row-level security policy in the database.

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