The catalog pg_user_mapping stores the mappings from local user to remote. Access to this catalog is restricted from normal users, use the view pg_user_mappings instead. Table 50-57. pg_user_mapping Columns Name Type References Description oid oid Row identifier (hidden attribute; must be explicitly selected) umuser oid pg_authid.oid OID of the local role being mapped, 0 if the user mapping is public umserver oid pg_foreign_server.oid The OID of the foreign server that contains this mapping

The pg_ts_config_map catalog contains entries showing which text search dictionaries should be consulted, and in what order, for each output token type of each text search configuration's parser. PostgreSQL's text search features are described at length in Chapter 12. Table 50-51. pg_ts_config_map Columns Name Type References Description mapcfg oid pg_ts_config.oid The OID of the pg_ts_config entry owning this map entry maptokentype integer A token type emitted by the configuration's parser

The pg_ts_template catalog contains entries defining text search templates. A template is the implementation skeleton for a class of text search dictionaries. Since a template must be implemented by C-language-level functions, creation of new templates is restricted to database superusers. PostgreSQL's text search features are described at length in Chapter 12. Table 50-54. pg_ts_template Columns Name Type References Description oid oid Row identifier (hidden attribute; must be explicitly s

The pg_ts_config catalog contains entries representing text search configurations. A configuration specifies a particular text search parser and a list of dictionaries to use for each of the parser's output token types. The parser is shown in the pg_ts_config entry, but the token-to-dictionary mapping is defined by subsidiary entries in pg_ts_config_map. PostgreSQL's text search features are described at length in Chapter 12. Table 50-50. pg_ts_config Columns Name Type References Description

The pg_ts_dict catalog contains entries defining text search dictionaries. A dictionary depends on a text search template, which specifies all the implementation functions needed; the dictionary itself provides values for the user-settable parameters supported by the template. This division of labor allows dictionaries to be created by unprivileged users. The parameters are specified by a text string dictinitoption, whose format and meaning vary depending on the template. PostgreSQL's text sear

The pg_ts_parser catalog contains entries defining text search parsers. A parser is responsible for splitting input text into lexemes and assigning a token type to each lexeme. Since a parser must be implemented by C-language-level functions, creation of new parsers is restricted to database superusers. PostgreSQL's text search features are described at length in Chapter 12. Table 50-53. pg_ts_parser Columns Name Type References Description oid oid Row identifier (hidden attribute; must be

The catalog pg_trigger stores triggers on tables and views. See CREATE TRIGGER for more information. Table 50-49. pg_trigger Columns Name Type References Description oid oid Row identifier (hidden attribute; must be explicitly selected) tgrelid oid pg_class.oid The table this trigger is on tgname name Trigger name (must be unique among triggers of same table) tgfoid oid pg_proc.oid The function to be called tgtype int2 Bit mask identifying trigger firing conditions tgenabled char Cont

The view pg_timezone_abbrevs provides a list of time zone abbreviations that are currently recognized by the datetime input routines. The contents of this view change when the timezone_abbreviations run-time parameter is modified. Table 50-80. pg_timezone_abbrevs Columns Name Type Description abbrev text Time zone abbreviation utc_offset interval Offset from UTC (positive means east of Greenwich) is_dst boolean True if this is a daylight-savings abbreviation While most timezone abbreviations

The catalog pg_tablespace stores information about the available tablespaces. Tables can be placed in particular tablespaces to aid administration of disk layout. Unlike most system catalogs, pg_tablespace is shared across all databases of a cluster: there is only one copy of pg_tablespace per cluster, not one per database. Table 50-47. pg_tablespace Columns Name Type References Description oid oid Row identifier (hidden attribute; must be explicitly selected) spcname name Tablespace name

The catalog pg_transform stores information about transforms, which are a mechanism to adapt data types to procedural languages. See CREATE TRANSFORM for more information. Table 50-48. pg_transform Columns Name Type References Description trftype oid pg_type.oid OID of the data type this transform is for trflang oid pg_language.oid OID of the language this transform is for trffromsql regproc pg_proc.oid The OID of the function to use when converting the data type for input to the procedural l