topic [resolved] How to insert row in PostgreSQL using ST_GeographyFromText - Postgis? in Installing and Upgrading

[resolved] How to insert row in PostgreSQL using ST_GeographyFromText - Postgis?

Anonymous — Sat, 16 Nov 2024 11:28:26 GMT

Hi all,
I have a job like two pictures below.
I have :
+ input: excel file (id, longitude, latitude)
+ output: postgresql's table (id , location ) and data type of " location"column is " geometry"
When inserting new record I have to call function " ST_GeographyFromText" in database ( ex: INSERT INTO out_put_table VALUES (1,ST_GeographyFromText('POINT(106.667010 10.776100)')::geometry); )
My question: can I call function "ST_GeographyFromText" in tmap (when mapping data) ? if not, could you give me several solutions ?
I reviewed: tPostgresqlSP, tPostgresqlRow component (but I think It can not use in this scenario)
Many thanks.

Re: [resolved] How to insert row in PostgreSQL using ST_GeographyFromText - Postgis?

Anonymous — Fri, 10 Oct 2014 04:27:20 GMT

I resolved by using tPostgresqlRow (do not use tMap)
t_connection ------(subjob ok)------ t_excel_input ------(main)------ t_PostgresqlRow ------(subjob ok)------ t_PostgresqlCommit
t_PostgressqlRow query (basic setting) : "insert into out_put_value (id, location) values (" + row1.id + "," + "ST_GeographyFromText(" + " ' " + "POINT(" + row1.longitude + " " + row1.latitude + ")" + " ' " + ")::geometry" + " ) ;"
Thanks for reading.

Re: [resolved] How to insert row in PostgreSQL using ST_GeographyFromText - Postgis?

_AnonymousUser — Wed, 15 Oct 2014 12:46:50 GMT

hi mrjody,
are you tested you solution ? how t_PostgressqlRow can know row1.id?
Tanks.

Re: [resolved] How to insert row in PostgreSQL using ST_GeographyFromText - Postgis?

Anonymous — Tue, 21 Oct 2014 10:51:36 GMT

@nono1: yes, of course I tested.
t_excel_input component: it is refered to an excel file with three columns (id, longitude, latitude)
"How t_PostgresqlRow can know row1.id?" --> it depend on Talend mechanism.
You can read from:
1/ link 1
2/ link 2
Regard.