Skip to main content
Question

How do I automatically set/read data type when using SQLCreator and reading data from PostgreSQL/PostGIS database? My FeatureWriter (to FFS) has all the data types set to varchar(200).

  • October 23, 2020
  • 1 reply
  • 65 views
robert.wright
Contributor
Forum|alt.badge.img

I have a workspace with several SQLCreators that executes a query to retrieve data from a postgreSQL/PostGIS database.

 

After some manipulation of the data I then am sending it to a FeatureWriter (to FFS) and all the data types are defined as varchar(200) when many of the original attributes from PostgreSQL/PostGIS are of different data types.

 

I have looked through documentation, searched in community and it appears my only option is to change/switch the featurewriter from "automatic" for Attribute definition to "manual" and define everything by hand. It doesn't appear that "dynamic" option will do what I need either as some of the original attributes being pulled for the PostgreSQL/PostGIS database have been renamed. (i.e. select attr555 as display_name from mytable)

 

Is there another option than manually changing the data type for each feature within the featurewriter?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

A
  • alexist
  • November 6, 2020

Hello !

 

You can import your database schema in the featurewritter. Hope that helps.

 

 

1 Attachments

Community Stats

32,182
Posts
122,179
Replies
39,856
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.