数据仓库服务 GAUSSDB(DWS)-DBA_TAB_COLUMNS:应用示例

时间：2024-06-29 17:51:04

数据仓库服务 GAUSSDB(DWS) 系统视图

应用示例

查询指定schema下的所有表字段信息：

  
       SELECt * FROM DBA_TAB_COLUMNS WHERE schema = 'public';
  owner  | table_name | column_name | data_type | column_id | data_length | comments | avg_col_len | nullable | data_precision | data_scale | char_length | schema | kind
---------+------------+-------------+-----------+-----------+-------------+----------+-------------+----------+----------------+------------+-------------+--------+-------
 dbadmin | t_customer | id          | int4      |         1 |           4 | 主键     |             | n        |                |          0 |           0 | public | table
 dbadmin | student    | sschool     | varchar   |         4 |          10 |          |             | n        |                |          0 |          10 | public | table
 dbadmin | student    | ssex        | varchar   |         3 |          10 |          |             | n        |                |          0 |          10 | public | table
 dbadmin | student    | sname       | varchar   |         2 |          10 |          |             | n        |                |          0 |          10 | public | table
 dbadmin | student    | sid         | varchar   |         1 |          10 |          |             | n        |                |          0 |          10 | public | table
 dbadmin | t_customer | email       | varchar   |         4 |          32 | email    |             | n        |                |          0 |          32 | public | table
 dbadmin | t_customer | gender      | varchar   |         3 |          10 | 性别     |             | n        |                |          0 |          10 | public | table
 dbadmin | t_customer | cust_name   | varchar   |         2 |          32 | 名字     |             | n        |                |          0 |          32 | public | table
(8 rows)