aboutsummaryrefslogtreecommitdiffstats
path: root/sql/dump_file_meta.sql
blob: 1028c13547e9f062c42b4d4c99fb65f785054175 (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 '/grande/snapshots/file_meta_dump.tsv'
WITH NULL '';

ROLLBACK;