Revision 57531
Added by Michele Artini over 4 years ago
importNewRels.sql | ||
---|---|---|
10 | 10 |
|
11 | 11 |
COPY tmp_simrels(local_id, oa_original_id, oa_name, oa_acronym, oa_country, oa_url, oa_collectedfrom) FROM '/Users/michele/Develop/dnet45/dnet-orgs-database-application/src/main/resources/tmp_data/rels.part-r-00000.tsv' DELIMITER E'\t';; |
12 | 12 |
|
13 |
DELETE FROM openaire_simrels WHERE reltype = 'suggested'; |
|
14 |
|
|
13 | 15 |
INSERT INTO openaire_simrels (local_id, oa_original_id, oa_name, oa_acronym, oa_country, oa_url, oa_collectedfrom) |
14 | 16 |
SELECT local_id, oa_original_id, oa_name, oa_acronym, oa_country, oa_url, oa_collectedfrom |
15 | 17 |
FROM tmp_simrels |
Also available in: Unified diff
new authentication