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
  • 52 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?

1 reply

  • November 6, 2020

Hello !

 

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

 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings