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