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

[Shaozhong SHI]

Hi, Simon,

That is very interesting.

Thank you.

Regards,

Shao

On Mon, 2 Sep 2019 at 10:36, Simon (SPDBA) Greener <
simon at spatialdbadvisor.com> wrote:

> 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
> <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 2 Sep. 2019, 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
>> <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 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
>>
>> _______________________________________________
> 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/fcd3f27b/attachment.html>