[postgis-users] Split polygon by line

[Arnaud L.]

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