Skip to main content
Question

How to change PostGIS Reader varchar width on certain fields

  • June 13, 2021
  • 2 replies
  • 98 views
rudystricklan1
Contributor
Forum|alt.badge.img+2

I'm reading a PostGIS database layer that is formatted as 'Text'. PostGIS treats this as basically an unlimited-width VARCHAR field. However, the FME PostGIS Reader truncates this field's input to 80 characters, and I can't get it to change to accommodate more characters.

2 replies

M
Forum|alt.badge.img+2

@rudystricklan1​ I haven't been able to reproduce your issue in FME 2021 using the following example data:

CREATE TABLE longtext
(
    longtext text ,
    longvarchar character varying(150) ,
    longchar character(150) 
);
 
insert into longtext values ('123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*',
							 '123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*',
							'123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*');

When I read this data back in FME the 'text' field reads all 120 characters.  Perhaps you can use this small example to replicate your problem and then we can chase down the cause.

rudystricklan1
Contributor
Forum|alt.badge.img+2

@rudystricklan1​ I haven't been able to reproduce your issue in FME 2021 using the following example data:

CREATE TABLE longtext
(
    longtext text ,
    longvarchar character varying(150) ,
    longchar character(150) 
);
 
insert into longtext values ('123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*',
							 '123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*',
							'123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*123456789*');

When I read this data back in FME the 'text' field reads all 120 characters.  Perhaps you can use this small example to replicate your problem and then we can chase down the cause.

Thanks, Mark. Actually, the solution was to change the *writer* parameter to 150. It seems odd that it isn't the PostGIS Reader parameters that control the amount of data read in per field. Please make this issue as solved!

Rudy Stricklan

Community Stats

32,749
Posts
124,193
Replies
41,251
Members
Terms & ConditionsAccessibility 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.