pushd C:\Program Files\PostgreSQL\9.1\bin set PGPASSWORD=abracadabra psql.exe -U biblivre -d biblivre4 -c "with q as (select name, encode((CAST(single.digital_media.id as VARCHAR) || ':' || single.digital_media.\"name\")::bytea, 'base64') as photo_id from single.digital_media) update single.users set photo_id = q.photo_id from q, single.digital_media where q.\"name\" = (single.users.\"name\" || '.png');" pause