Created
November 8, 2016 22:16
-
-
Save stompro/8e08647dd1d25793e69e0edfd5015718 to your computer and use it in GitHub Desktop.
Boopsie Data Extract
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--- Boopsie Extract | |
--List of opac visible records | |
select aovc.record | |
from asset.opac_visible_copies aovc | |
where aovc.record > 0 | |
group by 1 | |
order by 1 | |
; | |
\copy select aovc.record from asset.opac_visible_copies aovc where aovc.record > 0 group by 1 order by 1 to full_bib_id_list.txt | |
; | |
-- Output ID's to a file. | |
export LANG=C #for speed | |
sort input1.txt input2.txt input2.txt | uniq -u | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment