Frequently used commands when working with postgresql databases on Ubuntu, like creating and deleting databases and users. https://help.ubuntu.com/community/PostgreSQL

pgsql_commands.sh

# create user and database with user as admin
sudo -u postgres createuser -D -A -P uname
sudo -u postgres createdb -O uname dbname

# delete database and user
sudo -u postgres dropdb dbname
sudo -u postgres dropuser uname

# dump and import data
pg_dump --clean -U uname dbname > dump.sql
psql --password -U uname dbname < dump.sql