Boopsie Data Extract

Notes.txt

--- 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