postgres drop all tables

By admin | 01.08.2018

Удалим схему и создадим опять ее же)

DROP SCHEMA public CASCADE;
CREATE SCHEMA public;

1 2	DROP SCHEMA public CASCADE; CREATE SCHEMA public;

Дадим привелегии

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

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