NAME dropdb - remove a PostgreSQL database SYNOPSIS dropdb [ connection-option ...] [ option ...] dbname DESCRIPTION dropdb destroys ... superuser or the owner of the database. dro…more convenient to use the program dropdb (1) instead, which is a wrapper around thisCREATE 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