selectc.relnameas表名,cast(obj_description(c.oid)asvarchar)as表注释,a.attnumas字段序号,a.attnameas字段名,d.descriptionas字段注释,concat_ws('',t.typname,replace(substring(format_type(a.atttypid,a.atttypmod)from'\(.*\)'),',0',''))as字段类型,casewhen a.attnum=any(con.conkey)then'...
cast( obj_description(relfilenode,'pg_class')asvarchar )名称, d.description字段备注, a.attname字段, concat_ws( '', t.typname, SUBSTRING( format_type(a.atttypid,a.atttypmod) from '\(.*\)' ) )as字段类型 from pg_class c, pg_attribute a, pg_type t, pg_description d where a.att...
obj_description(relfilenode,'pg_class')asvarchar )名称, d.description字段备注, a.attname字段, concat_ws( '', t.typname, SUBSTRING( format_type(a.atttypid,a.atttypmod) from '\(.*\)' ) )as字段类型 from pg_class c, pg_attribute a, pg_type t, pg_description d where a.attnum>0...
PG_DESCRIPTION系统表可以给每个数据库对象存储一个可选的描述(注释)。许多内置的系统对象的描述提供了PG_DESCRIPTION的初始内容。 这个表的功能类似PG_SHDESCRIPTION,用于记录整个集群范围内共享对象的注释。 表1 PG_DESCRIPTION字段 名称 类型 引用 描述 objoid oid 任意OID属性 这条描述所描述的对象的OID。 class...
表注释:cast( obj_description ( relfilenode, 'pg_class' ) AS VARCHAR ) AS COMMENT relnamespace:表对应的模式id pg_tables 模式名:schemaname 表名:tablename tableowner pg_authid.rolname Name of table's owner tablespace pg_tablespace.spcname Name of tablespace containing table (null if default...
relfilenode的rewrite table后会发生变化
目录pg_description存储对每一个数据库对象可选的描述(注释)。描述可以通过COMMENT操作,并可使用psql的\d命令查看。在pg_description的初始内容中提供了很多内建系统对象的描述。
SELECT pgd.description as field_description, pgc.relname as table_name, pg_attribute.attname as field_name FROM pg_description pgd JOIN pg_class pgc ON pgd.objoid = pgc.oid JOIN pg_attribute ON pgd.objsubid = pg_attribute.attnum 复制代码 这样就可以查看到表字段的注释信息。 0 赞 0 踩最...
如果别的schem下有相同的表名称的表,就会出现脏数据 SELECTDISTINCTC.relnameASTABLE_NAME,obj_description(C.oid)ASdescriptionFROM(SELECTDISTINCTtablename,schemanameFROMpg_tablesWHEREschemaname='ep'ANDPOSITION('_2'INtablename)=0)tsLEFTJOINpg_classCONC.relname=ts.tablenameWHEREC.relkind='r';
FROM pg_class c, pg_attribute a LEFT JOIN pg_description b ON a.attrelid = b.objoid AND a.attnum = b.objsubid, pg_type t WHERE c.relname = '实际的表名' AND a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid ...