root/inputs/NY/Ecatalog_all/create.sql @ 8801
| 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); |