The catalog pg_tablespace stores information about the available tablespaces. Tables can be placed in particular tablespaces to aid administration

PostgreSQL offers data types to store IPv4, IPv6, and MAC addresses, as shown in Table 8-21. It is better to use these types instead of plain

NameDROP RULE -- remove a rewrite rule 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

For convenience there are also single letter command-line option switches available for some parameters. They are described in Table 19-2. Some of these options exist for historical

Before anyone can access the database, you must start the database server. The database server program is called postgres. The

Durability is a database feature that guarantees the recording of committed transactions even if the server crashes or loses power. However, durability adds significant database

The catalog pg_database stores information about the available databases. Databases are created with the

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