NameDROP TRIGGER -- remove a trigger Synopsis
An index can support only one collation per index column. If multiple collations are of interest, multiple indexes may be needed. Consider these
There are several ways to shut down the database server. You control the type of shutdown by sending different signals to the master postgres process
The catalog pg_tablespace stores information about the available tablespaces. Tables can be placed in particular tablespaces to aid administration
The pg_prewarm module provides a convenient way to load relation data into either the operating system buffer cache or the
PostgreSQL offers data types to store IPv4, IPv6, and MAC addresses, as shown in Table 8-21. It is better to use these types instead of plain
SP-GiST is an abbreviation for space-partitioned GiST. SP-GiST supports
The view pg_user provides access to information about database users. This is simply a publicly readable view of
The view pg_file_settings provides a summary of the contents of the server's configuration file(s). A row appears in this view for each
Create vs. insert Insertion into a GIN index can be slow due to the likelihood of many keys
Page 50 of 60