[postgis-users] MakeLine into new layer

[Shane Carey]

Hi,
I am trying to find the longest line of a polygon and insert it into a new
line. I can create the makeline as in the code below but cannot create a
new layer out of it using the INTO keyword. Any help would be appreciated.
Thanks

SELECT
   ST_MakeLine(St_LongestLine(
    (SELECT geom FROM floodplainw
    WHERE id = 1),
    (SELECT geom FROM floodplainw
    WHERE id = 1))
);


Le gach dea ghui,
*Shane Carey*
*GIS and Data Solutions Consultant*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20181022/19b6b940/attachment.html>