Here are two simple examples I've created. Hope they are useful.
https://www.spdba.com.au/?p=599 Simon 39 Cliff View Drive, Allens Rivulet, Tas 7150 (H) 0362396397 (M) 0418396391 www.spatialdbadvisor.com / www.spdba.com.au Sent from BlueMail On 2 Sep. 2019, 05:29, at 05:29, "Simon (SPDBA) Greener" <[email protected]> wrote: >Yes it does. > >I will post an example this week. > >Simon > >39 Cliff View Drive, Allens Rivulet, Tas 7150 >(H) 0362396397 >(M) 0418396391 >www.spatialdbadvisor.com / www.spdba.com.au > >Sent from BlueMail > >On 1 Sep. 2019, 23:42, at 23:42, Shaozhong SHI <[email protected]> >wrote: >>Hi, Simon, >>Thanks. >>Does that mean XML xquery can been run in psql command line? >>Regards, >>Shao >> >>On Sunday, 1 September 2019, Simon (SPDBA) Greener < >>[email protected]> wrote: >> >>> Yes. >>> >>> One method is to copy the gml into a table (column declared as text >>or >>> xml). Then use XML XQUERY processing to shred the GML document into >>nodes >>> that ST_GeomFromGML() can consume. >>> >>> Simon >>> >>> 39 Cliff View Drive, Allens Rivulet, Tas 7150 >>> >><https://www.google.com/maps/search/39+Cliff+View+Drive,+Allens+Rivulet,+Tas+7150?entry=gmail&source=g> >>> (H) 0362396397 >>> (M) 0418396391 >>> <http://www.spatialdbadvisor.com>www.spatialdbadvisor.com / >>> <http://www.spdba.com.au>www.spdba.com.au >>> >>> Sent from BlueMail <http://www.bluemail.me/r?b=15487> >>> On 1 Sep. 2019, at 16:57, Shaozhong SHI <[email protected]> >>wrote: >>>> >>>> Hi, all, >>>> Can psql copy gml into postgis? >>>> Regards, >>>> Shao >>>> >>>> ------------------------------ >>>> >>>> postgis-users mailing list >>>> [email protected] >>>> https://lists.osgeo.org/mailman/listinfo/postgis-users >>>> >>>> >> >> >>------------------------------------------------------------------------ >> >>_______________________________________________ >>postgis-users mailing list >>[email protected] >>https://lists.osgeo.org/mailman/listinfo/postgis-users > > >------------------------------------------------------------------------ > >_______________________________________________ >postgis-users mailing list >[email protected] >https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
