I'm using Postgis functions
st_split to split a polygon based on line. Now, after splitting; output geometry stores in a database table as well. Here is the query:
insert into aoo(geom) SELECT ST_AsTEXT ((ST_Dump(ST_Split(circle, line))).geom) As wkt FROM (SELECT ST_GeomFromText('LINESTRING(73.33393335342407 33.82005181729661,73.33685159683228 33.80960466650892)',4326) As line, (select geom As circle from aoo where gid=71) ) As foo;
But, the issue is I want to store other data with these geometries as well. Like
insert into aoo(geom,name)
but I don't what is the way to do it.