Hey.. i know u r not a lazy DBA......
Ever had to re-load a postgres database without having the
privileges needed to create a database/schema nor the ones needed to
drop it ?
Case In Point;- On OpenShift (RedHat Cloud) you cannot drop the provided database nor create another one...
The schema had so many tables, thus dropping each table one by one is never an option.
After some googling i came up with this.. and found it worthwile to share;
run DELETE SCHEMA public CASCADE;
then CREATE SCHEMA public;
voila!!!!!!
No comments:
Post a Comment
Feel free to leave a comment