Felix, Awesome - that worked great.
Bryan -----Original Message----- From: postgis-users [mailto:[email protected]] On Behalf Of Felix Kunde Sent: Wednesday, July 11, 2018 09:29 To: [email protected] 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" <[email protected]> An: "PostGIS Users Discussion" <[email protected]> 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 [email protected] 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 [email protected] 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). _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
