How to load LINESTRING to postgresql using Talend

[Udhayavardhane]

Hi All,

We have a txt file with geometry data like LINESTRING(-71.160281 42.258729,-71.160837 42.259113,-71.161144 42.25932)

Our requirement is, we want to load this data into postgresql database, with geometry column

How can we do this ? Please help!

Thanks & Regards,

Udhaya vardhane N.P

[Anonymous]

Are you using Postgis or are you Postgres without Postgis?

http://postgis.net/workshops/postgis-intro/geometries.html talks about this.

Have you tried to load this data with a Talend job already? If so, where are you struggling with this?

Since I do not have Postgres (or Postgis) configured, I cannot try out all of the scenarios that your question could relate to. I'll need more information.

[Udhayavardhane]

hi,

We have postgres with Postgis enabled.

Till now we were using .shp file with dGeometryToPostgisObject component. Where both input and output we could set as Geometry. That works fine & perfect.

But now our input file is a plain text file with string value like LINESTRING(-71.160281 42.258729,-71.160837 42.259113,-71.161144 42.25932). So when we are trying to build the metadata , the datatype of the field is string. But posgresql table has the datatype as geometry.

So we are not able to use dGeometryToPostgisObject & dproject.

Basically we need an idea , how to load the string from flat file to postgres-postgis geometry column using Talend.

Thanks