Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Authoring
  • 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).

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?

Hello !

 

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

 

 

Reply


Community Stats

30,418
Posts
115,551
Replies
38,228
Members
Terms & ConditionsCookie settings
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.