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
Type Conversion: Value Storage
  • References/Database/PostgreSQL/Type Conversion

Values to be inserted into a table are converted to the destination column's data type according to the following steps.

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

NameALTER CONVERSION -- change the definition of a conversion Synopsis

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

NameEND -- commit the current transaction Synopsis

2025-01-10 15:47:30
ALTER TEXT SEARCH TEMPLATE
  • References/Database/PostgreSQL/Commands

NameALTER TEXT SEARCH TEMPLATE -- change the definition of a text search template

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

The auto_explain module provides a means for logging execution plans of slow statements automatically, without having to run

2025-01-10 15:47:30
START TRANSACTION
  • References/Database/PostgreSQL/Commands

NameSTART TRANSACTION -- start a transaction block Synopsis

2025-01-10 15:47:30