[resolved] How to insert row in PostgreSQL using ST_GeographyFromText - Postgis?
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?
@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.