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

[Simon (SPDBA) Greener]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190902/833b4fd4/attachment.html>