摘要：
select st_asgeojson(geom) geom, st_asgeojson(st_centriod(geom)) "centerJson" from xxxtable where geom is not null and st_intersects(geom,ST_geomFromTe 阅读全文
2024年8月5日
摘要：
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 阅读全文
