This video demonstrates how to drop all tables from a database. You have to use those commands
1. sudo -u postgres
2. psql
3. \c [database_name]
4.
DROP SCHEMA public CASCADE;
CREATE SCHEMA public;

GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO public;

#PostgreSQL #SQL #database #Ubuntu #Terminal

свернуть