I have a problem with a PostgreSQL table. It is the result of a query that joins 77 tables with 4 columns (geom, inicio, fuente, temporada). I used ST_SRID and ST_Transform because I could not join tables with different SRID.
When I want to export it as shapefile QGIS can not display the file, it does not recognize it. I tried to insert a column ID_0 but the problem continues.
Consulting on this table resulting some sub tables and I could export as a shape, but not others. I do not know if the table is missing some metadata, or did something wrong with the reprojection.