-- key is unique only within each Ecatalog* table
SELECT ('Ecatalog_LatLong', key)::pkey AS pkey, * FROM "Ecatalog_LatLong"
UNION ALL
SELECT ('Ecatalog', key)::pkey AS pkey, * FROM "Ecatalog"
;

-- UniqueNYInternalRecordNumber is sometimes duplicated
ALTER TABLE :table ADD PRIMARY KEY (pkey);