[postgis-users] [EXTERNAL] Re: Change the type in geometry_columns

[Bryan Hall]

Felix,

Awesome - that worked great.

Bryan

-----Original Message-----
From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Felix Kunde
Sent: Wednesday, July 11, 2018 09:29
To: postgis-users at lists.osgeo.org
Subject: [EXTERNAL] Re: [postgis-users] Change the type in geometry_columns

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://urldefense.proofpoint.com/v2/url?u=https-3A__lists.osgeo.org_mailman_listinfo_postgis-2Dusers&d=DwIGaQ&c=M7nMI6M-Uv3ihEfN-QJ3_sQdVexoO64eU4Ftr4lnVk0&r=-89XSUoV_kZKlHf89FQGuyqPyUjA53juyA-7r7GoZVA&m=xxeJoSIJ1_m94ROw26Pb8UZXkofHb0q5O5L2FJ8Izl0&s=5TmnYbCLhnBYtKZGBXIz9tGg0JY-ZAtYXtjr6UBU17Y&e=
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.osgeo.org_mailman_listinfo_postgis-2Dusers&d=DwIGaQ&c=M7nMI6M-Uv3ihEfN-QJ3_sQdVexoO64eU4Ftr4lnVk0&r=-89XSUoV_kZKlHf89FQGuyqPyUjA53juyA-7r7GoZVA&m=xxeJoSIJ1_m94ROw26Pb8UZXkofHb0q5O5L2FJ8Izl0&s=5TmnYbCLhnBYtKZGBXIz9tGg0JY-ZAtYXtjr6UBU17Y&e=

________________________________

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).