Le 18/10/2018 à 18:43, Shane Carey a écrit :
Yep, I run the following:

SELECT ST_Split(circle, line)
INTO qlayer
FROM (SELECT
     ST_MakeLine(ST_MakePoint(10, 10),ST_MakePoint(190, 190)) As line,
     ST_Buffer(ST_GeomFromText('POINT(100 90)'), 50) As circle) As foo;

But this layer does not show up as a gis layer in qgis?

Probably because the geometry_columns table is not populated.
Try to either create the destination table first and then to insert in it, or maybe just run :
SELECT Populate_Geometry_Columns();

Thanks in advance for your help. Sorry, what do you mean by top post?

https://en.wikipedia.org/wiki/Posting_style
Bottom or interleaved posting are the preferred style.

--
Arnaud
_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users

Reply via email to