 -- Create a table that contains all generators (RE and conventional) but no duplicates. 
 ------------
 
-DROP TABLE IF EXISTS orig_geo_powerplants.generators_total;
+/* DROP TABLE IF EXISTS orig_geo_powerplants.generators_total;
 
 CREATE TABLE orig_geo_powerplants.generators_total
 (

--------------


DROP TABLE orig_geo_powerplants.pf_generator_single;

CREATE TABLE orig_geo_powerplants.pf_generator_single
(

);

ALTER TABLE orig_geo_powerplants.pf_generator_single
  OWNER TO oeuser; */


DELETE FROM orig_geo_powerplants.pf_generator_single; 

INSERT INTO orig_geo_powerplants.pf_generator_single (generator_id)
	SELECT un_id
