<html><head></head><body><div dir="auto">Yes.<br><br></div>
<div dir="auto">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.<br><br></div>
<div dir="auto">Simon<br><br></div>
<div dir="auto"><!-- tmjah_g_1299s -->39 Cliff View Drive, Allens Rivulet, Tas 7150<!-- tmjah_g_1299e --><br></div>
<div dir="auto"><!-- tmjah_g_1299s -->(H) 0362396397<!-- tmjah_g_1299e --><br></div>
<div dir="auto"><!-- tmjah_g_1299s -->(M) 0418396391<!-- tmjah_g_1299e --><br></div>
<div dir="auto"><a href="http://www.spatialdbadvisor.com"><!-- tmjah_g_1299s --><a href="http://www.spatialdbadvisor.com">www.spatialdbadvisor.com</a><!-- tmjah_g_1299e --></a><!-- tmjah_g_1299s --> / <!-- tmjah_g_1299e --><a href="http://www.spdba.com.au"><!-- tmjah_g_1299s --><a href="http://www.spdba.com.au">www.spdba.com.au</a><!-- tmjah_g_1299e --></a><br><br></div>
<div dir="auto"><!-- tmjah_g_1299s -->Sent from <!-- tmjah_g_1299e --><a href="http://www.bluemail.me/r?b=15487"><!-- tmjah_g_1299s -->BlueMail<!-- tmjah_g_1299e --></a><!-- tmjah_g_1299s --> <!-- tmjah_g_1299e --></div>
<div class="gmail_quote" >On 1 Sep. 2019, at 16:57, Shaozhong SHI <<a href="mailto:shishaozhong@gmail.com" target="_blank">shishaozhong@gmail.com</a>> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hi, all,<div>Can psql copy gml into postgis?</div><div>Regards,</div><div>Shao</div>
<pre class="blue"><hr><br>postgis-users mailing list<br>postgis-users@lists.osgeo.org<br><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre></blockquote></div></body></html>