Catalogs: pg_language
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_language registers languages in which you can write functions or stored procedures. See

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
Information Functions
  • References/Database/PostgreSQL/Functions/System Information

Table 9-59 shows several functions that extract session and system information. In addition to the functions listed in this section, there are

2025-01-10 15:47:30
Standby Server Settings
  • References/Database/PostgreSQL/Recovery Configuration

standby_mode (boolean) Specifies whether to start the

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
Catalogs: pg_opclass
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_opclass defines index access method operator classes. Each operator class defines semantics for index columns of a particular

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

The catalog pg_rewrite stores rewrite rules for tables and views. Table 50-41

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

The process of retrieving or the command to retrieve data from a database is called a query. In SQL the

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

Namecreateuser -- define a new PostgreSQL user account

2025-01-10 15:47:30