Project

General

Profile

1 7239 leinfelder
-- on KNB, we copy this to the file to transfer to LTER
2
-- COPY identifier TO '/tmp/knb_identifier.csv' WITH CSV HEADER;
3
-- scp to LTER
4
5
/**
6
 * LTER begin here
7
 */
8
-- create the table to house the information
9
CREATE TABLE knb_identifier AS SELECT * FROM identifier WHERE false;
10
-- on LTER, we load this
11
COPY knb_identifier FROM '/tmp/knb_identifier.csv' WITH CSV HEADER;
12 7283 leinfelder
-- remove the non-doi entries since we don't need them for the update
13
DELETE knb_identifier WHERE guid NOT LIKE 'doi%';
14
15 7239 leinfelder
-- update the guids on LTER
16
BEGIN;
17
18
UPDATE identifier lter_id
19
SET guid = knb_id.guid
20
FROM knb_identifier knb_id
21
WHERE knb_id.docid = lter_id.docid
22
AND knb_id.rev = lter_id.rev;
23
24
COMMIT;
25
26
-- clean up
27
DROP TABLE knb_identifier;