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

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

GIN stands for Generalized Inverted Index. GIN is designed for handling cases where the items to be indexed

PostgreSQL provides the standard SQL type boolean; see Table 8-19. The

NameALTER DEFAULT PRIVILEGES -- define default access privileges Synopsis

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

The view pg_views provides access to useful information about each view in the database.

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

NameCOMMENT -- define or change the comment of an object Synopsis

WITH provides a way to write auxiliary statements for use in a larger query. These statements, which are often referred to as Common Table Expressions