[postgis-users] Can psql copy gml into postgis?

[Simon (SPDBA) Greener]

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" <simon at spatialdbadvisor.com> 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 <shishaozhong at gmail.com>
>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 <
>>simon at spatialdbadvisor.com> 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 <shishaozhong at gmail.com>
>>wrote:
>>>>
>>>> Hi, all,
>>>> Can psql copy gml into postgis?
>>>> Regards,
>>>> Shao
>>>>
>>>> ------------------------------
>>>>
>>>> postgis-users mailing list
>>>> postgis-users at lists.osgeo.org
>>>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>>>
>>>>
>>
>>
>>------------------------------------------------------------------------
>>
>>_______________________________________________
>>postgis-users mailing list
>>postgis-users at lists.osgeo.org
>>https://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at lists.osgeo.org
>https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190902/5ea02ad4/attachment.html>