Simple script to delete files from records stored in a PostgreSQL database

delete_images.sh

#!/bin/sh
l=1000
psql_cmd="/usr/local/bin/psql"

while [ 1 ];
do
  records=`$psql_cmd -U syslog_writer -d vigilante -t << EOF
DELETE FROM images_logs WHERE id IN (SELECT id  FROM images_logs ORDER BY uploaded_at LIMIT $l);
EOF`

done