【gp】取gp数据库某表的字段名、注释和排序号
【SQL】
select attname as name, attnum as orderNum, col_description(attrelid,attnum) as remark from pg_attribute where attrelid='your table'::regclass and attnum>0 order by attnum asc
END
【SQL】
select attname as name, attnum as orderNum, col_description(attrelid,attnum) as remark from pg_attribute where attrelid='your table'::regclass and attnum>0 order by attnum asc
END