The catalog pg_description stores optional descriptions (comments) for each database object. Descriptions can be manipulated with the

NameDROP USER MAPPING -- remove a user mapping for a foreign server Synopsis

Table 9-30 shows the available functions for date/time value processing, with details appearing in the following subsections. Table 9-29 illustrates the behaviors of the basic

The examples in the previous section illustrated full text matching using simple constant strings. This section shows how to search table data, optionally using indexes.

The view pg_seclabels provides information about security labels. It as an easier-to-query version of the

NameCREATE FOREIGN TABLE -- define a new foreign table Synopsis

Namepg_config -- retrieve information about the installed version of PostgreSQL

For enum types (described in Section 8.7), there are several functions that allow cleaner programming

NameDROP FOREIGN TABLE -- remove a foreign table Synopsis

The tsearch2 module provides backwards-compatible text search functionality for applications that used tsearch2