Locale Support
  • References/Database/PostgreSQL/Localization

Locale support refers to an application respecting cultural preferences regarding alphabets, sorting, number formatting, etc.

2025-01-10 15:47:30
ALTER OPERATOR
  • References/Database/PostgreSQL/Commands

NameALTER OPERATOR -- change the definition of an operator Synopsis

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

Namepg_controldata -- display control information of a PostgreSQL database cluster

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

Table 50-1 lists the system catalogs. More detailed documentation of each catalog follows below. Most system catalogs are copied from the template

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

The catalog pg_collation describes the available collations, which are essentially mappings from an SQL name to operating system locale categories

2025-01-10 15:47:30
CREATE LANGUAGE
  • References/Database/PostgreSQL/Commands

NameCREATE LANGUAGE -- define a new procedural language Synopsis

2025-01-10 15:47:30
Trigger Functions
  • References/Database/PostgreSQL/Functions/Trigger

Currently PostgreSQL provides one built in trigger function, suppress_redundant_updates_trigger, which will prevent

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

As with any server daemon that is accessible to the outside world, it is advisable to run PostgreSQL under a separate user account. This user

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

Table 9-36 shows the operators available for the cidr and inet types. The operators <<

2025-01-10 15:47:30
Routine Reindexing
  • References/Database/PostgreSQL/Maintenance

In some situations it is worthwhile to rebuild indexes periodically with the REINDEX command or a series

2025-01-10 15:47:30