SELECT
tablename,
indexname,
indexdef
FROM
pg_indexes
WHERE
tablename = ‘ecological_red_lines_kashi_region4490’
ORDER BY
tablename,
indexname;
PGsql查询表的坐标系
select st_srid(geom) from table;
PostGIS修改geometry字段的坐标系
SELECT updategeometrysrid(‘tablename’,‘geom’,4490);
select * from information_schema.columns
where table_schema=‘public’ and table_name='表名称 ';