Project

General

Profile

Download (294 Bytes) Statistics
| Revision:

root/inputs/NY/Ecatalog_all/create.sql @ 9949

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);