uuid-ossp
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

The uuid-ossp module provides functions to generate universally unique identifiers (UUIDs) using one of several standard algorithms. There are

2025-01-10 15:47:30
Date/Time Input Interpretation
  • References/Database/PostgreSQL/Appendixes/DateTime Support

The date/time type inputs are all decoded using the following procedure. Break the input

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

The tcn module provides a trigger function that notifies listeners of changes to any table on which it is attached. It must be used as an

2025-01-10 15:47:30
Date/Time Key Words
  • References/Database/PostgreSQL/Appendixes/DateTime Support

Table B-1 shows the tokens that are recognized as names of months. Table B-1. Month Names

2025-01-10 15:47:30
Date/Time Configuration Files
  • References/Database/PostgreSQL/Appendixes/DateTime Support

Since timezone abbreviations are not well standardized, PostgreSQL provides a means to customize the set of abbreviations accepted by the server

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

The pgcrypto module provides cryptographic functions for PostgreSQL.

2025-01-10 15:47:30
PostgreSQL Error Codes
  • References/Database/PostgreSQL/Appendixes/Appendixes

All messages emitted by the PostgreSQL server are assigned five-character error codes that follow the SQL standard's conventions for

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

The tsm_system_time module provides the table sampling method SYSTEM_TIME, which can be used in the

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

The pg_prewarm module provides a convenient way to load relation data into either the operating system buffer cache or the

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

This module implements a data type seg for representing line segments, or floating point intervals. seg can represent uncertainty

2025-01-10 15:47:30