-- Export paths are {outputRoot}/{showId}/[{episode}]/{shotCode}/{version}. -- A stored "render.outputRoot" of "//SAN/renders" injected a stray "renders/" -- segment; strip it so the root is just the SAN mount point. UPDATE "system_config" SET "value" = regexp_replace("value", '/+renders/*$', '') WHERE "key" = 'render.outputRoot' AND "value" ~ '/+renders/*$';