1. about dumping -----pg_dump -h 10.0.253.110 -U postgres legendary -t festivals > dump.sql
2. create or drop table in psql terminal
psql -h ... -U user -d dbname
DROP TABLE must be upper (大写)
3. create database or drop database
psql -h db -U postgres -c "CREATE DATABASE gerrit"
psql -h db -U postgres -c DROP DATABASE gerrit"
2. create or drop table in psql terminal
psql -h ... -U user -d dbname
DROP TABLE must be upper (大写)
for detail see
http://articles.slicehost.com/2009/7/14/postgresql-creating-and-dropping-tables3. create database or drop database
psql -h db -U postgres -c "CREATE DATABASE gerrit"
psql -h db -U postgres -c DROP DATABASE gerrit"