pg_dump -C -s --file=schema.txt {name}
scp schema.txt prakhar@{external server}:/home/prakhar

dropdb {name}
createdb {name}
psql --file=schema.txt {name}