Revisions to How can I drop all the tables in a PostgreSQL database?

added 83 characters in body

edited Oct 4, 2021 at 16:14

3.2k
1
29
22

Following steps might be helpful (For linux users):

At first enter the postgres command prompt by following command:
```
sudo -u postgres psql 
```
Enter the database by this command (my database name is: maoss):
```
\c maoss 
```

Now enter the command for droping all tables:

DROP SCHEMA public CASCADE; CREATE SCHEMA public; GRANT ALL ON SCHEMA public TO postgres; GRANT ALL ON SCHEMA public TO public;

Now exit from psql by following command:
```
\q 
```

Following steps might be helpful (For linux users):

At first enter the postgres command prompt by following command:
```
sudo -u postgres psql 
```
Enter the database by this command (my database name is: maoss):
```
\c maoss 
```

Now enter the command for droping all tables:

DROP SCHEMA public CASCADE; CREATE SCHEMA public; GRANT ALL ON SCHEMA public TO postgres; GRANT ALL ON SCHEMA public TO public;

Following steps might be helpful (For linux users):

At first enter the postgres command prompt by following command:
```
sudo -u postgres psql 
```
Enter the database by this command (my database name is: maoss):
```
\c maoss 
```

Now enter the command for droping all tables:

DROP SCHEMA public CASCADE; CREATE SCHEMA public; GRANT ALL ON SCHEMA public TO postgres; GRANT ALL ON SCHEMA public TO public;

Now exit from psql by following command:
```
\q 
```

added 97 characters in body

Source Link

edited May 24, 2020 at 20:10

Farid Chowdhury

3.2k
1
29
22

Following steps might be helpful (For linux users):

At first enter the postgres command prompt by following command:
```
sudo -u postgres psql 
```
Enter the database by this command (my database name is: maoss):
```
\c maoss 
```

Now enter the command for droping all tables:

DROP SCHEMA public CASCADE; CREATE SCHEMA public;   GRANT ALL ON SCHEMA public TO postgres; GRANT ALL ON SCHEMA public TO public;

Following steps might be helpful (For linux users):

At first enter the postgres command prompt by following command:
```
sudo -u postgres psql 
```
Enter the database by this command (my database name is: maoss):
```
\c maoss 
```

Now enter the command for droping all tables:

DROP SCHEMA public CASCADE; CREATE SCHEMA public;

Following steps might be helpful (For linux users):

At first enter the postgres command prompt by following command:
```
sudo -u postgres psql 
```
Enter the database by this command (my database name is: maoss):
```
\c maoss 
```

Now enter the command for droping all tables:

DROP SCHEMA public CASCADE; CREATE SCHEMA public;   GRANT ALL ON SCHEMA public TO postgres; GRANT ALL ON SCHEMA public TO public;

added 28 characters in body

Source Link

edited Apr 2, 2020 at 14:48

Farid Chowdhury

3.2k
1
29
22

Following steps might be helpful (For linux users):

At first enter the postgres command prompt by following command:
```
sudo -u postgres psql 
```
Enter the database by this command (my database name is: maoss):
```
\c maoss 
```

Now enter the command for droping all tables:

DROP SCHEMA public CASCADE; CREATE SCHEMA public;

Following steps might be helpful (For linux users):

At first enter the postgres command prompt by following command:
```
sudo -u postgres psql 
```
Enter the database by this command (my database name is: maoss):
```
\c maoss 
```
Now enter the command for droping all tables:
```
DROP SCHEMA public CASCADE; 
```

Following steps might be helpful (For linux users):

At first enter the postgres command prompt by following command:
```
sudo -u postgres psql 
```
Enter the database by this command (my database name is: maoss):
```
\c maoss 
```

Now enter the command for droping all tables:

DROP SCHEMA public CASCADE; CREATE SCHEMA public;

format code blocks

Source Link

edited Mar 27, 2020 at 15:32

Paul Roub

36.5k
27
88
95

Loading

Source Link

answered Mar 27, 2020 at 15:18

Farid Chowdhury

3.2k
1
29
22

Loading

Collectives™ on Stack Overflow

Return to Answer