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;
|