Created
November 6, 2022 02:40
-
-
Save januszm/184fc06b4152c4c69624818c2b7b8056 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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