Database Reference
In-Depth Information
The query adds the result in QGIS as a temporary layer.
5. Now, let us modify the query to create a table in the database rather than
load the query as a layer, byexecuting the following command:
CREATE TABLE "Chp11".roads_buffer_sp AS
SELECT gid, ST_Buffer(geom_sp, 10) AS
geom, fullname, roadflg FROM
"Chp11".lines WHERE roadflg = 'Y'
The following screenshot shows theCuyahoga Country Road Network:
Search WWH ::




Custom Search