This section describes the storage format at the level of files and directories. Traditionally, the configuration and data files used by a database

Bit strings are strings of 1's and 0's. They can be used to store or visualize bit masks. There are two SQL bit types: bit(n)

Each unlogged table, and each index on an unlogged table, has an initialization fork. The initialization fork is an empty table or index of the appropriate type. When an unlogged

The catalog pg_cast stores data type conversion paths, both built-in and user-defined. It should be noted that

The current limitations of PostgreSQL's text search features are: The

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

NameDROP TRANSFORM -- remove a transform Synopsis

NameSET TRANSACTION -- set the characteristics of the current transaction Synopsis

Name ecpg -- embedded SQL C preprocessor Synopsis

The catalog pg_rewrite stores rewrite rules for tables and views. Table 50-41