column_comment columnComment, column_key columnKey, extraFROMinformation_schema.COLUMNSWHEREtable_name ='表名称'ANDtable_schema = (SELECTDATABASE ( ) )ORDERBYordinal_position desc表名称 PostgreSQL查询: SELECT*FROMinformation_schema.COLUMNSWHEREtable_schema='public'ANDtable_name=表名称; 复杂一点的 SELE...
COMMENT ON COLUMN public.tb_car.car_id IS '主键'; COMMENT ON COLUMN public.tb_car.car_index_code IS '车辆编码'; COMMENT ON COLUMN public.tb_car.plate_no IS '车牌号码'; 用如下语句查询 SELECT col.table_name, col.column_name, col.ordinal_position AS o, d.description FROM information_...
COMMENTONTABLEschema2023.some_infoIS'一些信息'; COMMENTONCOLUMNschema2023.some_info.idIS'主键'; COMMENTONCOLUMNschema2023.some_info.nameIS'名称'; COMMENTONCOLUMNschema2023.some_info.moneyIS'价值:人民币计价'; COMMENTONCOLUMNschema2023.some_info.daysIS'有效天数'; COMMENTONCOLUMNschema2023.some_info....
select col.table_schema, col.table_name, col.ordinal_position, col.column_name, col.data_type, col.character_maximum_length, col.numeric_precision, col.numeric_scale, col.is_nullable, col.column_default, des.description from information_schema.columns col left join pg_description des on col.t...
用如下语句查询 SELECT col.table_name, col.column_name, col.ordinal_position AS o, d.description FROM information_schema.columns col JOIN pg_class c ON c.relname = col.table_name LEFT JOIN pg_description d ON d.objoid = c.oid AND d.objsubid = col.ordinal_position WHERE col.table_sch...
information_schema pg_catalog 然后还有个默认的schema,就是public。 创建表时,如果不指定的schema,那么默认在public下创建表。 information_schema和pg_catalog相当于库,所以查询的时候后面一定要加点号指定范围: 以下2种错误写法: select * from information_schema; 错 ...
grant select,insert,update,delete on all tables in schema public to 用户名; 撤回权限 #撤回在public模式下的权限 revoke select on all tables in schema public from 用户名; #撤回在information_schema模式下的权限 revoke select on all tables in schema information_schema from 用户名; ...
在这个查询中,我们使用了'schema_name'::regnamespace来获取模式的OID,并指定对象类型为'pg_namespace',表示模式。 执行这个查询后,将返回模式的注释内容。 对于PostgreSQL中的模式注释,可以通过以下方式进行应用和管理: 创建模式注释:使用COMMENT ON SCHEMA schema_name IS 'comment'语句来创建模式注释。其中,sche...
v_ret.fields_comment=v_rec.fields_comment; SELECT constraint_name INTO v_key FROM information_schema.key_column_usage WHERE table_schema=a_schema_name AND table_name=a_table_name AND column_name=v_rec.fields_name; IF FOUND THEN v_ret.fields_key_name=v_key; ...
CREATE SCHEMA ALTER SCHEMA CREATE EXTENSION COMMENT SET CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION SET CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER TABLE ALTER SEQUENCE CREATE TABLE ALTER TABLE SET