> SELECT
> DISTINCT phone,
> company_name,
> address,
> state,
> idc_desc_1,
> street_number,
> street_name,
> street_xtra,
> suburb,
> postcode,
> area_code,
> ac_phone,
> fax_area_code,
> fax_phone,
> fax_ac_phone,
> latitude,
> longitude
> INTO export_temp
> FROM export;
SELECT DISTINCT ON (phone) phone, company_name, address, state, idc_desc_1, street_number, street_name,
street_xtra, suburb, postcode, area_code, ac_phone, fax_area_code, fax_phone, fax_ac_phone, latitude,
longitude
INTO export_temp
FROM export;