<html><head></head><body><div dir="auto">Here are two simple examples I've created.<br><br></div>
<div dir="auto">Hope they are useful.<br><br></div>
<div dir="auto"><a href="https://www.spdba.com.au/?p=599">https://www.spdba.com.au/?p=599</a><br><br></div>
<div dir="auto">Simon<br><br><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 2 Sep. 2019, at 05:29, "Simon (SPDBA) Greener" <<a href="mailto:simon@spatialdbadvisor.com" target="_blank">simon@spatialdbadvisor.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;">
<div dir="auto">
Yes it does.
<br>
<br>
</div>
<div dir="auto">
I will post an example this week.
<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>
<a href="http://www.spatialdbadvisor.com">www.spatialdbadvisor.com</a>
<!-- tmjah_g_1299e -->
<!-- tmjah_g_1299s --> /
<!-- tmjah_g_1299e -->
<a href="http://www.spdba.com.au">
<!-- tmjah_g_1299s --></a>
<a href="http://www.spdba.com.au">www.spdba.com.au</a>
<!-- tmjah_g_1299e -->
<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 23:42, 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, Simon,
<div>
Thanks.
</div>
<div>
Does that mean XML xquery can been run in psql command line?
</div>
<div>
Regards,
</div>
<div>
Shao
<br>
<br>On Sunday, 1 September 2019, Simon (SPDBA) Greener <
<a href="mailto:simon@spatialdbadvisor.com">simon@spatialdbadvisor.com</a>> wrote:
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<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">
<a href="https://www.google.com/maps/search/39+Cliff+View+Drive,+Allens+Rivulet,+Tas+7150?entry=gmail&source=g">39 Cliff View Drive, Allens Rivulet, Tas 7150</a>
<br>
</div>
<div dir="auto">
(H) 0362396397
<br>
</div>
<div dir="auto">
(M) 0418396391
<br>
</div>
<div dir="auto">
<a href="http://www.spatialdbadvisor.com" target="_blank"></a>
<a href="http://www.spatialdbadvisor.com" target="_blank">www.spatialdbadvisor.com</a> /
<a href="http://www.spdba.com.au" target="_blank"></a>
<a href="http://www.spdba.com.au" target="_blank">www.spdba.com.au</a>
<br>
<br>
</div>
<div dir="auto">
Sent from
<a href="http://www.bluemail.me/r?b=15487" target="_blank">BlueMail</a>
</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> <hr><br>postgis-users mailing list<br><a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a></pre>
</blockquote>
</div>
</div>
</blockquote>
</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>
<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>