/ - Diff - Metacat - Ecoinformatics Redmine

« Previous | Next »

Revision 7288

update the table to indicate which DOI account we are targeting
https://redmine.dataone.org/issues/2815

     update doi_registration
     set title = regexp_replace(title, E'^\\s+', '', 'g');
     update doi_registration
     set ezid_account = 'KNB'
     where guid like 'doi:10.5063%';
     --16988
     update doi_registration
     set ezid_account = 'PISCO'
     where guid like 'doi:10.6085%';
     --98078
     update doi_registration
     set ezid_account = 'LTER'
     where guid like 'doi:10.6073%';
     --49482
     COPY (select ezid_account, guid as doi, url, title, creator, publisher, pub_date from doi_registration order by doi)
     TO '/tmp/doi_registration.csv'
     WITH CSV HEADER;
     --164548
     --drop table doi_registration;

Also available in: Unified diff