Currently PostgreSQL provides one built in trigger function, suppress_redundant_updates_trigger, which will prevent
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
Table 9-36 shows the operators available for the cidr and inet types. The operators <<
In some situations it is worthwhile to rebuild indexes periodically with the REINDEX command or a series
Values to be inserted into a table are converted to the destination column's data type according to the following steps.
NameALTER CONVERSION -- change the definition of a conversion Synopsis
NameEND -- commit the current transaction Synopsis
NameALTER TEXT SEARCH TEMPLATE -- change the definition of a text search template
The auto_explain module provides a means for logging execution plans of slow statements automatically, without having to run
NameSTART TRANSACTION -- start a transaction block Synopsis
Page 7 of 60