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

Shaozhong SHI shishaozhong at gmail.com
Sun Sep 1 06:41:48 PDT 2019


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


More information about the postgis-users mailing list