SELECT *

FROM taxonobservation

LEFT JOIN taxoninterpretation USING (taxonobservation_id)

LEFT JOIN plantconcept_ USING (plantconcept_id)

;

ALTER TABLE :table DROP COLUMN row_num;