Sometimes I need a way to manipulate my database but I dont want to fuss with my main data. So here is a quick way to copy a database:

create database <newdb> with template <originaldb> owner <dbuser>;