黑子菜园

摘要： select st_asgeojson(geom) geom, st_asgeojson(st_centriod(geom)) "centerJson" from xxxtable where geom is not null and st_intersects(geom,ST_geomFromTe 阅读全文

摘要： select *, row_number() over(PARTITION by 某某字段 order by 排序字段) as rn from table 例子： select * from （ select *, row_number() over(PARTITION by 某某字段 order 阅读全文

摘要： select t.table_name, obj_description(c.oid) as table_comment from information_schema.tables t left join pg_class c on t.table_name::text = c.relname w 阅读全文