A PostgreSQL database cluster contains one or more named databases. Users and groups of users are shared across the entire cluster, but no
Table 9-47 shows the operators available for array types. Table 9-47. Array Operators
Object identifiers (OIDs) are used internally by PostgreSQL as primary keys for various system tables. OIDs are not added to user-created tables
The catalog pg_foreign_server stores foreign server definitions. A foreign server describes a source of external data, such as a remote server
This style guide is offered in the hope of maintaining a consistent, user-friendly style throughout all the messages generated by PostgreSQL
dict_xsyn (Extended Synonym Dictionary) is an example of an add-on dictionary template for full-text search. This dictionary type replaces words
The file_fdw module provides the foreign-data wrapper file_fdw, which can be used to access data files in the server's
Namepg_dump -- extract a PostgreSQL database into a script file or other archive file
The examples shown below use tables in the PostgreSQL regression test database. The outputs shown are taken from version 8.3. The behavior
Namepg_rewind -- synchronize a PostgreSQL data directory with another data directory that was forked from it
Page 25 of 60