ADM_TAB_COLUMNS
ADM_TAB_COLUMNS displays information about the columns of tables. Each column of each table in the database has a row of data in ADM_TAB_COLUMNS. By default, only the SYSADMIN can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schemas.
Name | Type | Description |
|---|---|---|
owner | character varying(64) | Table owner. |
table_name | character varying(64) | Table name. |
column_name | character varying(64) | Column name. |
data_type | character varying(128) | Data type of the column. |
data_length | integer | Length of the column, in bytes. |
data_precision | integer | Precision of a data type. This column is valid for the numeric data type and NULL for other data types. |
data_scale | integer | Number of decimal places. This column is valid for the numeric data type and 0 for other data types. |
nullable | bpchar | Specifies whether a column can be empty (n for a primary key constraint or NOT NULL constraint). |
column_id | integer | Sequence number of the column when the table is created. |
avg_col_len | numeric | Average length of a column, in bytes. |
char_length | numeric | Column length (in characters) which is valid only for the varchar, nvarchar2, bpchar, and char types. |
comments | text | Comments. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
