PostgreSQL implements portions of the SQL/MED specification, allowing you to access data that resides outside PostgreSQL using regular SQL

The xml data type can be used to store XML data. Its advantage over storing XML data in a text field is that it checks the

For additional information on tuning these settings, see Section 30.4.

The geometric types point, box, lseg, line, path

NameCREATE TEXT SEARCH CONFIGURATION -- define a new text search configuration

This module implements a data type seg for representing line segments, or floating point intervals. seg can represent uncertainty

NameALTER LANGUAGE -- change the definition of a procedural language Synopsis

Numeric types consist of two-, four-, and eight-byte integers, four- and eight-byte floating-point numbers, and selectable-precision decimals. Table 8-2 lists the available

The pg_ts_config catalog contains entries representing text search configurations. A configuration specifies a particular text search parser

The catalog pg_attribute stores information about table columns. There will be exactly one pg_attribute row