SELECT
B.SCHEMANAME AS gp_schema ,
B.TABLENAME AS gp_tableName ,
CAST(OBJ_DESCRIPTION(RELFILENODE,'pg_class') AS VARCHAR ) AS gp_tableDesc,
t1.attname AS gp_colName ,
t3.description as gp_colDesc,
t2.typname AS gp_colType ,
case when t1.attnotnull=true then 'Y' else null end as gp_colIsnull,
t4.adsrc as gp_colDefault,
case when t5.attrnums is not null then 'Y' else null end as gp_colIsdistribution,
case when t5.attrnums is not null then t5.attrnums else null end as gp_colIsdistricols,
case when t6.indisunique=true or t6.indisprimary=true then
greenplum获取表信息
最新推荐文章于 2023-11-22 10:09:34 发布
本文介绍如何在Greenplum数据库中查询和获取表的元数据信息,包括表结构、字段、索引等关键信息。对于数据库管理员和开发者来说,了解这些信息对于理解和操作数据库至关重要。
摘要由CSDN通过智能技术生成