Notes

select * from files where snapshot_id in (select id from snapshots where cloud_folder_id = 720 and current = 'true' and is_temp = 'false') and name = 'LQunash';


SELECT id, name, buildPath(parent_guid_device, parent_guid_version, snapshot_id, deleted, false) AS path FROM files WHERE id = 961058204;


select id,name,guid_device,guid_version,snapshot_id from files where snapshot_id in ( select id from snapshots where cloud_folder_id = 720 and current = true and is_temp = false ) and id = 961058204;
select id,name,guid_device,guid_version,snapshot_id from files where snapshot_id in ( select id from snapshots where cloud_folder_id = 720 and current = true and is_temp = false ) and id = 961058204;

COPY (WITH RECURSIVE file AS (SELECT f.* FROM files f WHERE f.parent_guid_device = '12c508d1-2f63-4161-9ab5-df72c2e9558d' AND f.parent_guid_version = 390147314 AND f.snapshot_id = 355942328 UNION ALL SELECT f.* FROM files f INNER JOIN file f1 ON f.snapshot_id = f1.snapshot_id AND f.parent_guid_device = f1.guid_device AND f.parent_guid_version = f1.guid_version) SELECT id FROM file ORDER BY snapshot_id, buildpath(parent_guid_device, parent_guid_version, snapshot_id, deleted, false), name) TO '/usr/local/lib/ctera/postgres/fileIdsToTouch.txt';