aboutsummaryrefslogtreecommitdiffstats
path: root/sql/dump_file_meta.sql
blob: a7d6c2b340662bcc576ab1edc8e5b2b6440ef7e3 (plain)
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;