test_decoding is an example of a logical decoding output plugin. It doesn't do anything especially useful, but can serve as a starting point for

Table 8-4. Character Types Name Description

NameCREATE GROUP -- define a new database role Synopsis

While the server is running, it is not possible for a malicious user to take the place of the normal database server. However, when the server is down, it is possible for a

The tsm_system_time module provides the table sampling method SYSTEM_TIME, which can be used in the

The pgcrypto module provides cryptographic functions for PostgreSQL.

NameALTER FUNCTION -- change the definition of a function Synopsis

The PostgreSQL type system contains a number of special-purpose entries that are collectively called pseudo-types

NameDECLARE -- define a cursor Synopsis

Table 9-59 shows several functions that extract session and system information. In addition to the functions listed in this section, there are