Postgres Pro AXE : Documentation: 1: 38.18. pga_proxy

38.18. `pga_proxy_table`
Prev	Up	Chapter 38. Metadata Tables	Home	Next

38.18. `pga_proxy_table` #

This metadata table contains information about proxy tables. For more information about proxy tables, refer to Chapter 22.

Column Name	Column Type	Constraint	Description
`proxy_table_id`	`BIGINT`	Primary key	The proxy table ID.
`proxy_table_name`	`VARCHAR`	`NOT NULL`	The proxy table name identifying the associated pgpro_metastore object. The name is in the following format: `prefix`_`object_name`_`object_number` Where: `prefix`: The prefix that determines the type of the pgpro_metastore object. Possible values: `s` for storages `t` for analytical tables `f` for shared directories `object_name`: The first 22 characters of the pgpro_metastore object name. `object_number`: A sequence number for the pgpro_metastore object. Since the `object_name` is limited to the first 22 characters, this number allows distinguishing pgpro_metastore objects whose names start with the same characters. Examples of proxy table names: `s_localstorage_00001` `t_hits_00002` `f_shared_00001`

Column Name

Column Type

Constraint

Description

proxy_table_id

BIGINT

Primary key

The proxy table ID.

proxy_table_name

VARCHAR

NOT NULL

The proxy table name identifying the associated pgpro_metastore object.

The name is in the following format:

  prefix_object_name_object_number

Where:

prefix: The prefix that determines the type of the pgpro_metastore object.
Possible values:
- s for storages
- t for analytical tables
- f for shared directories
object_name: The first 22 characters of the pgpro_metastore object name.
object_number: A sequence number for the pgpro_metastore object.
Since the object_name is limited to the first 22 characters, this number allows distinguishing pgpro_metastore objects whose names start with the same characters.

Examples of proxy table names:

Prev	Up	Next
38.17. `pga_transaction_log`	Home	Chapter 39. Reading Metadata

epub pdf