Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
When debugging programs, I need to frequently drop a database of Postgresql, and then re-create it again.
To convenient, I want to execute this in a single command line like following:
psql -c "DROP DATABASE my_db; CREATE DATABASE my_db;"
But I get a error:
ERROR: DROP DATABASE cannot run inside a transaction block
Is there a way I can do it? Thanks!
You can use the -c option repeatedly:
psql -c 'DROP DATABASE my_db' -c 'CREATE DATABASE my_db'
