NAME dropdb - remove a PostgreSQL database SYNOPSIS dropdb [ connection-option ...] [ option ...] dbname DESCRIPTION dropdb destroys ... superuser or the owner of the database. dro…CREATE DATABASE demo TEMPLATE template0; SEE ALSO dropdb (1), CREATE DATABASE ( CREATE_DATABASEdatabase and recreate it from the dump: $ dropdb mydb $ pg_restore -C -d postgres db.dump