DROP All VIEWS postgres

Question

I have a database with an old broken version of PostGIS installed in it. I would like to easily drop all views in the database (they're all from PostGIS). Is there a simple way to do this? Even simply extracting a list of views names would be acceptable as I could just make a large DROP VIEWS statement.? Thanks In Advance

Mike Sherrill 'Cat Recall' · Accepted Answer · 2012-11-30 14:11:59Z

2

This should give you a set of view names in the public schema. Replace 'sandbox' with the name of your database.

select table_name
from information_schema.views
where table_catalog = 'sandbox'
  and table_schema = 'public'

answered Nov 30, 2012 at 14:11

Mike Sherrill 'Cat Recall'

96.6k20 gold badges132 silver badges195 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Craig Ringer Over a year ago

+1, and Satish can wrap this up into a PL/PgSQL function using EXECUTE, string_agg and quote_ident to make a simple function to drop all views. S: To find out how, just do some searching, there are plenty of answers here that explain EXECUTE, format, etc.

Collectives™ on Stack Overflow

DROP All VIEWS postgres

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related