diff options
| -rw-r--r-- | sql/dump_unextracted_pdf.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/dump_unextracted_pdf.sql b/sql/dump_unextracted_pdf.sql new file mode 100644 index 0000000..4d264b9 --- /dev/null +++ b/sql/dump_unextracted_pdf.sql @@ -0,0 +1,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; |