dropbdb_list.sql

--Save out in dropdb.sh and execute with chmod +x 
--This delete all database of runbot app
SELECT 'dropdb ' || '"' || datname || '"' AS dropcmd
FROM pg_catalog.pg_database d
WHERE --datname ~ E'^\[0-9]{5}-[\w|\-|.]*'  AND
   pg_catalog.pg_get_userbyid(d.datdba) = 'runbot' 
  AND (datname like '%-base' OR datname like '%-all')
ORDER BY 1;