Skip to content

Instantly share code, notes, and snippets.

@januszm

januszm/postgis_rds_upgrade.sql

Created November 6, 2022 02:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save januszm/184fc06b4152c4c69624818c2b7b8056 to your computer and use it in GitHub Desktop.
Save januszm/184fc06b4152c4c69624818c2b7b8056 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
postgis_rds_upgrade.sql
DROP extension postgis CASCADE;
/*
drop cascades to column shape of table MYTABLE_points
drop cascades to column shape of table MYTABLE_areas
*/
/* Upgrade PostgreSQL */
CREATE extension postgis;
ALTER TABLE public.MYTABLE_points ADD COLUMN shape public.geometry(Point);
ALTER TABLE public.MYTABLE_areas ADD COLUMN shape public.geometry(MultiPolygon);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment