|| quote_ident(c.relname) || ' CASCADE ' AS name
'DROP SEQUENCE ' || quote_ident(n.nspname) || '.' DROP FUNCTION IF EXISTS remove_all() ĬREATE FUNCTION remove_all() RETURNS void AS $$ If you have the PL/PGSQL procedural language installed you can use the following to remove everything without a shell/Perl external script. Note: This bunch of commands are similar to the first point, so the Pros and cons will remain the same. Paste these commands: DROP SCHEMA public CASCADE Login using postgres user on your shell.When the other data entities are Important and you just want to delete only tables from the schema, this approach will really helpful to you. 'DROP TABLE IF EXISTS "' || tablename || '" CASCADE 'Īs you can see, By the use of subquery, We can remove the entire tables from the schema. PostgreSQL stores all the tables on its record table named pg_table. By using fetching all table names from pg_tables table. You'll lose other entities too like Functions, Views, Materialized views, etc. This will clean an entire Schema and re-create it as a new one. If you are using PostgreSQL 9.3 or greater, you may also need to restore the default grants.
Here, In general, we have a public schema by default. By dropping and recreating the current schema This is a really interesting question, and you'll get it done in Multiple ways: 1. If you have any extensions installed they will be dropped when you drop the schema, so you should make note of what you need installed and then execute statements as necessary. So to my mind the fully correct answer is: DROP SCHEMA public CASCADE ĬOMMENT ON SCHEMA public IS 'standard public schema' Īlso note to issue these commands in pgAdmin III, I used the Query tool ( magnifying glass icon "Execute abritrary SQL queries") or you could use Plugins-> PSQL Console However, by contrast a brand new database will have the following: - Schema: publicįor me using a python web framework which creates database tables (web2py), using the former caused problems: no schema has been selected to create in Under pgAdmin III for PostgreSQL 9.3.1, if you click on the "public" schema created this way and look in the "SQL pane" you will see the following: - Schema: public This does work, however if your intention is to restore the public schema to its virgin state this does not fully accomplish the task. The most accepted answer as of this writing (January 2014) is: drop schema public cascade
0 kommentar(er)
