The relevant command-line utilities are createdb and dropdb. Load data into a PostgreSQL database Database design is an art, not a science, and takes considerable experience to get right.