Drop table ignoring dependencies in PostgreSQL?

Question

Is there any way at all to drop a table in PostgreSQL ignoring dependencies (not using CASCADE)?

I'm attempting to drop and recreate a table in order to add an IDENTITY column (as there seems to be no other way to do this in AWS Redshift), but I've got views that are dependent on the table.

I obviously don't want to have to temporarily modify every dependent view just so that I can drop and recreate the same table with an added column.

Was trying to avoid having to do that, as it'll be a lot of overhead... — MJ.
– MJ., Commented May 27, 2015 at 17:05

Gurmokh · Accepted Answer · 2016-10-04 11:34:01Z

0

I can't find a way to do this.

I would do something like the following:

create table viewSQL
as select view_definition
from information_schema.views; 

drop table [table you want to change] cascade;

do $$
declare
record record ; 
lv_sql text; 
begin
for record in select view_definition 
              from viewSQL loop
                               execute immediate 'record.view_definition';
                           end loop; 
end $$

answered Oct 4, 2016 at 11:34

Gurmokh

2,09127 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

Drop table ignoring dependencies in PostgreSQL?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related