NameCREATE EXTENSION -- install an extension Synopsis

The pg_trgm module provides functions and operators for determining the similarity of alphanumeric text based on trigram matching, as well as

NamePREPARE -- prepare a statement for execution Synopsis

Another useful tool for monitoring database activity is the pg_locks system table. It allows the database administrator to view information

The catalog pg_foreign_server stores foreign server definitions. A foreign server describes a source of external data, such as a remote server

The lo module provides support for managing Large Objects (also called LOs or BLOBs). This includes a data type lo and

btree_gist provides GiST index operator classes that implement B-tree equivalent behavior for the data types int2,

Table 9-42 shows the operators that are available for use with the two JSON data types (see Section 8.14)

Table 9-47 shows the operators available for array types. Table 9-47. Array Operators

Namepg_dump -- extract a PostgreSQL database into a script file or other archive file