Mathematical operators are provided for many PostgreSQL types. For types without standard mathematical conventions (e.g., date/time types)

The view pg_timezone_names provides a list of time zone names that are recognized by SET TIMEZONE, along with their

You can update existing rows using the UPDATE command. Suppose you discover the temperature readings are all off by 2 degrees after November 28

It is a good idea to save the database server's log output somewhere, rather than just discarding it via /dev/null. The log output is invaluable

The character set support in PostgreSQL allows you to store text in a variety of character sets (also called encodings), including single-byte

Before you can do anything, you must initialize a database storage area on disk. We call this a database cluster. (The SQL

The behavior of a custom text search configuration can easily become confusing. The functions described in this section are useful for testing text search objects. You can

NameDROP CONVERSION -- remove a conversion Synopsis

NameREINDEX -- rebuild indexes Synopsis

PostgreSQL provides a rich set of tools for developers to manage concurrent access to data. Internally, data consistency is maintained by using