blob: 4d264b9c570b9315ff7350c9d3a43267c4b3cf24 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
-- Run like:
-- psql sandcrawler < dump_unextracted_pdf.sql > dump_unextracted_pdf.2019-09-23.json
BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE READ ONLY DEFERRABLE;
COPY (
SELECT row_to_json(cdx)
FROM grobid
LEFT JOIN cdx ON grobid.sha1hex = cdx.sha1hex
)
-- TO '/grande/snapshots/dump_unextracted_pdf.2020-06-25.json';
TO STDOUT
WITH NULL '';
ROLLBACK;
|
