In PostGIS, it is possible to use addgeometrycolumn more than once on the same table.
Example: I have one table "scenes" with many attributes, and 2 geometry columns: the_geom1 and the_geom2.
select addgeometrycolumn('scenes', 'the_geom1', 0, 'POLYGON', 2); select addgeometrycolumn('scenes', 'the_geom2', 0, 'POLYGON', 2);
In QGIS, when I display "scenes", it only displays the_geom1.
To display the features using the second geometry, I found a solution with :
create view v2 as select id,the_geom2 from scenes;
But I'd like to access all other fields; something like:
create view v2 as select * (except the_geom1),the_geom2 from scenes;