I've got an ST_Difference query runnning error free in PostGIS, and in PGAdmin I can see the output table but it's not viewable in QGIS - The table name appears in DB Manager but says "There is no entry in Geometry Columns".
What do i need to do to view the results?
Here's my query:
DROP TABLE IF EXISTS processing.newdifference; CREATE TABLE processing.newdifference AS SELECT 1 AS gid, ST_Difference(tdhab.geom, tdbuf.geom) AS "diff_geom" FROM processing."tdhab", processing."tdbuf";