GBase南大通用GBase8a库中如何查询表的列信息？

顶一下

支持一下

gbase> select * from information_schema.COLUMNS where TABLE_SCHEMA='test' and TABLE_NAME='test_parquet'\G;
*************************** 1. row ***************************
TABLE_CATALOG: NULL
TABLE_VC: vc198
TABLE_SCHEMA: test
TABLE_NAME: test_parquet
COLUMN_NAME: id
ORDINAL_POSITION: 1
COLUMN_DEFAULT: NULL
IS_NULLABLE: YES
DATA_TYPE: int
CHARACTER_MAXIMUM_LENGTH: NULL
CHARACTER_OCTET_LENGTH: NULL
NUMERIC_PRECISION: 10
NUMERIC_SCALE: 0
CHARACTER_SET_NAME: NULL
COLLATION_NAME: NULL
COLUMN_TYPE: int(11)
COLUMN_KEY:
EXTRA:
PRIVILEGES: select,insert,update,references
COLUMN_COMMENT:
*************************** 2. row ***************************
TABLE_CATALOG: NULL
TABLE_VC: vc198
TABLE_SCHEMA: test
TABLE_NAME: test_parquet
COLUMN_NAME: name
ORDINAL_POSITION: 2
COLUMN_DEFAULT: NULL
IS_NULLABLE: YES
DATA_TYPE: varchar
CHARACTER_MAXIMUM_LENGTH: 100
CHARACTER_OCTET_LENGTH: 400
NUMERIC_PRECISION: NULL
NUMERIC_SCALE: NULL
CHARACTER_SET_NAME: utf8mb4
COLLATION_NAME: utf8mb4_general_ci
COLUMN_TYPE: varchar(100)
COLUMN_KEY:
EXTRA:
PRIVILEGES: select,insert,update,references
COLUMN_COMMENT:
*************************** 3. row ***************************
TABLE_CATALOG: NULL
TABLE_VC: vc198
TABLE_SCHEMA: test
TABLE_NAME: test_parquet
COLUMN_NAME: age
ORDINAL_POSITION: 3
COLUMN_DEFAULT: NULL
IS_NULLABLE: YES
DATA_TYPE: int
CHARACTER_MAXIMUM_LENGTH: NULL
CHARACTER_OCTET_LENGTH: NULL
NUMERIC_PRECISION: 10
NUMERIC_SCALE: 0
CHARACTER_SET_NAME: NULL
COLLATION_NAME: NULL
COLUMN_TYPE: int(11)
COLUMN_KEY:
EXTRA:
PRIVILEGES: select,insert,update,references
COLUMN_COMMENT:
3 rows in set (Elapsed: 00:00:00.00)

枕簟暑风消，帘幕秋风动。月到夜来愁处明，只照团衾凤。去意杳无凭，别语愁难送。一纸鱼笺枕底香，且做新来梦。

千里黄云白日曛，北风吹雁雪纷纷。莫愁前路无知己，天下谁人不识君。六翮飘飖私自怜，一离京洛十余年。丈夫贫贱应未足，今日相逢无酒钱。

学习下。