Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| owner | varchar | 128 | √ | null |
|
|
||
| table_name | varchar | 128 | √ | null |
|
|
||
| column_name | varchar | 128 | √ | null |
|
|
||
| data_type | varchar | 128 | √ | null |
|
|
||
| data_type_mod | varchar | 3 | √ | null |
|
|
||
| data_type_owner | varchar | 128 | √ | null |
|
|
||
| data_length | float8 | 17,17 | √ | null |
|
|
||
| data_precision | float8 | 17,17 | √ | null |
|
|
||
| data_scale | float8 | 17,17 | √ | null |
|
|
||
| nullable | varchar | 1 | √ | null |
|
|
||
| column_id | float8 | 17,17 | √ | null |
|
|
||
| default_length | float8 | 17,17 | √ | null |
|
|
||
| data_default | text | 2147483647 | √ | null |
|
|
||
| num_distinct | float8 | 17,17 | √ | null |
|
|
||
| low_value | bytea | 2147483647 | √ | null |
|
|
||
| high_value | bytea | 2147483647 | √ | null |
|
|
||
| density | float8 | 17,17 | √ | null |
|
|
||
| num_nulls | float8 | 17,17 | √ | null |
|
|
||
| num_buckets | float8 | 17,17 | √ | null |
|
|
||
| last_analyzed | timestamp | 22 | √ | null |
|
|
||
| sample_size | float8 | 17,17 | √ | null |
|
|
||
| character_set_name | varchar | 44 | √ | null |
|
|
||
| char_col_decl_length | float8 | 17,17 | √ | null |
|
|
||
| global_stats | varchar | 3 | √ | null |
|
|
||
| user_stats | varchar | 3 | √ | null |
|
|
||
| avg_col_len | float8 | 17,17 | √ | null |
|
|
||
| char_length | float8 | 17,17 | √ | null |
|
|
||
| char_used | varchar | 1 | √ | null |
|
|
||
| v80_fmt_image | varchar | 3 | √ | null |
|
|
||
| data_upgraded | varchar | 3 | √ | null |
|
|
||
| histogram | varchar | 15 | √ | null |
|
|
||
| default_on_null | varchar | 3 | √ | null |
|
|
||
| identity_column | varchar | 3 | √ | null |
|
|
||
| evaluation_edition | varchar | 128 | √ | null |
|
|
||
| unusable_before | varchar | 128 | √ | null |
|
|
||
| unusable_beginning | varchar | 128 | √ | null |
|
|
Table contained 0 rows