[postgis-users] Change the type in geometry_columns

Felix Kunde felix-kunde at gmx.de
Wed Jul 11 07:29:23 PDT 2018

Simply alter the tables and use typmod:

ALTER TABLE my_table ALTER my_geom TYPE geometry(Polygon,4326);

Not sure, if Postgres will ask for explicit type conversion with USING. If you store hetrogenous geometry types in one column you will run into problems, of course.

Gesendet: Mittwoch, 11. Juli 2018 um 16:14 Uhr
Von: "Bryan Hall" <bryan.hall at chk.com>
An: "PostGIS Users Discussion" <postgis-users at lists.osgeo.org>
Betreff: [postgis-users] Change the type in geometry_columns

Is it possible to change the type attribute in the geometry_columns view? All the data I am migrating with FME from Oracle is being set to GEOMETRY and I’d like to set it to the appropriate type if possible.
I didn’t see anything in the manual on how to do that post 2.0 (if it is still possible).
Thanks in advance…
This email (and attachments if any) is intended only for the use of the individual or entity to which it is addressed, and may contain information that is confidential or privileged and exempt from disclosure under applicable law. If the reader of this email is not the intended recipient, or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by return email and destroy all copies of the email (and attachments if any). _______________________________________________ postgis-users mailing list postgis-users at lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users

More information about the postgis-users mailing list