Tag Info

New answers tagged


Disable any FKs pointing to the table Create table SAVE as SELECT * FROM A Truncate table A Begin to create a script with the following with xfer as (select cast ('a' as text) as targ_tab, cast ('b' as text) as from_tab) select xfer.*, tabs.table_name as targ_table_name, cols.table_name as from_table_name, 'alter table ' || tabs.table_name || ' add (' ...

Top 50 recent answers are included