root/inputs/NY/Ecatalog_all/create.sql @ 11927
1 |
-- key is unique only within each Ecatalog* table
|
---|---|
2 |
SELECT ('Ecatalog_LatLong', key)::pkey AS pkey, * FROM "Ecatalog_LatLong" |
3 |
UNION ALL |
4 |
SELECT ('Ecatalog', key)::pkey AS pkey, * FROM "Ecatalog" |
5 |
;
|
6 |
|
7 |
-- UniqueNYInternalRecordNumber is sometimes duplicated
|
8 |
ALTER TABLE :table ADD PRIMARY KEY (pkey); |