CREATE VIEW new_line ASSELECTpoint1.gid,ST_MakeLine(point1.geom, point2.geom)FROM point1, point2WHERE point1.gid = point2.gid;It's possible to load the layer but QGIS says 'There is no entry in geometry_columns!'. The SRID is missing, too...