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

[Bryan Hall]

Classification: DCL-Internal

Hi Dan,

That looks great - but where is that setting? I'm running 2018.0 and I don't see it in either the parameters under the writer connection, or the feature type parameters for the table writer. I am using dynamic mode, but didn't see it if I changed that back to non-dynamic mode either.

Bryan

From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Daniel Baston
Sent: Wednesday, July 11, 2018 09:25
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: [EXTERNAL] Re: [postgis-users] Change the type in geometry_columns

Hello Bryan,

You should be able to control this by setting "Create Generic Geometry Columns" to "No" in the settings for your PostGIS writer:
https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/postgis/PostGIS_writer.htm<https://urldefense.proofpoint.com/v2/url?u=https-3A__docs.safe.com_fme_html_FME-5FDesktop-5FDocumentation_FME-5FReadersWriters_postgis_PostGIS-5Fwriter.htm&d=DwMFaQ&c=M7nMI6M-Uv3ihEfN-QJ3_sQdVexoO64eU4Ftr4lnVk0&r=-89XSUoV_kZKlHf89FQGuyqPyUjA53juyA-7r7GoZVA&m=s3Dm7hlAErtWlQLLQaXL-43mk0AG1K0N0WGkr95N1_8&s=JPWAW3RmmQyX87lBFGGB0vaSF755fOZPSS2u29UU4hk&e=>

Dan

On Wed, Jul 11, 2018 at 10:14 AM Bryan Hall <bryan.hall at chk.com<mailto:bryan.hall at chk.com>> wrote:
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<mailto:postgis-users at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/postgis-users<https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.osgeo.org_mailman_listinfo_postgis-2Dusers&d=DwMFaQ&c=M7nMI6M-Uv3ihEfN-QJ3_sQdVexoO64eU4Ftr4lnVk0&r=-89XSUoV_kZKlHf89FQGuyqPyUjA53juyA-7r7GoZVA&m=s3Dm7hlAErtWlQLLQaXL-43mk0AG1K0N0WGkr95N1_8&s=aWlRIrEMsjno9VXhfbyRit8iyOCw-yDsk7hRbCmKKv4&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).
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20180711/c747cc4f/attachment.html>