Revision 7283
Added by ben leinfelder almost 12 years ago
| LTER_DOI_conversion.sql | ||
|---|---|---|
| 9 | 9 |
CREATE TABLE knb_identifier AS SELECT * FROM identifier WHERE false; |
| 10 | 10 |
-- on LTER, we load this |
| 11 | 11 |
COPY knb_identifier FROM '/tmp/knb_identifier.csv' WITH CSV HEADER; |
| 12 |
-- remove the non-doi entries since we don't need them for the update |
|
| 13 |
DELETE knb_identifier WHERE guid NOT LIKE 'doi%'; |
|
| 14 |
|
|
| 12 | 15 |
-- update the guids on LTER |
| 13 | 16 |
BEGIN; |
| 14 | 17 |
|
Also available in: Unified diff
remove the non-doi identifiers before updating the LTER - should save time on the update.
https://redmine.dataone.org/issues/2858