sql/dump_file_meta.sql


1
2
3
4
5
6
7
8
9
10
11
12


BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE READ ONLY DEFERRABLE;

COPY (
  SELECT sha1hex, row_to_json(file_meta)
  FROM file_meta
  ORDER BY sha1hex ASC
)
TO '/srv/sandcrawler/tasks/file_meta_dump.tsv'
WITH NULL '';

ROLLBACK;