How to drop multiple databases in PostgreSQL

drop-multiple-datatbases-with-postgresql.md

1. Connect to PostgreSQL server via command line: psql -d postgre
2. At the prompt, type SQL query to construct DROP DATABASE statement then that statement via \gexec meta-command
3. Replace test with your desired pattern

Some alternative ways :

• Anonymous code block
• Using a shell script

SELECT 'DROP DATABASE ' || quote_ident(datname) || ';'
FROM pg_database
WHERE datname LIKE 'test%' AND datistemplate=false

\gexec

Thanks :)