CREATE EXTENSION postgis;
SELECT * FROM pg_available_extensions WHERE name = 'postgis';
SELECT AddGeometryColumn ('tb1', 'the_geom', 4326, 'POINT', 2);
ALTER TABLE tb1 ADD COLUMN the_geom geometry(Point, 4326);
--ERROR: type "geometry" does not exist
-- 檢查 PostGIS 是否已安裝
SELECT * FROM pg_available_extensions WHERE name = 'postgis';
-- 如果未啟用,則手動啟用 PostGIS
CREATE EXTENSION IF NOT EXISTS postgis;
ALTER TABLE tb1 ADD COLUMN the_geom geometry(Point, 4326);
-- 方法2:使用 PostGIS 的 AddGeometryColumn(舊方式,但仍然可用)
SELECT AddGeometryColumn('tb1', 'the_geom2', 4326, 'POINT', 2);
-- 或者帶 schema 名(如果表不在 public 模式)
SELECT AddGeometryColumn('public', 'tb1', 'the_geom3', 4326, 'POINT', 2);
浙公網安備 33010602011771號