When you no longer need a particular database, you can delete it using the SQL Data Manager in the PSQL Control Center. See the PSQL User's Guide for more information.