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.
Question
How to change PostGIS Reader varchar width on certain fields
@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.
+2- Contributor
- 8 replies
@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.
Rudy Stricklan