--выполнять в 1 сессии, по 1-й команде за раз.
CREATE TABLE public.old_table
(
t_id serial NOT NULL
,fld text
,PRIMARY KEY (t_id)
)
;
INSERT into public.old_table (fld) 
select concat (g::text,'::',timestamp'now') from generate_series(0,100) g;

create table new_table (
LIKE public.old_table
INCLUDING DEFAULTS
--INCLUDING IDENTITY --9.6
INCLUDING CONSTRAINTS
INCLUDING INDEXES
-- INCLUDING STORAGE
INCLUDING COMMENTS
);
ALTER TABLE old_table INHERIT new_table;

-----trick-prepare---------
select dblink.dblink_connect('session1' ,concat('dbname=',current_database(),' port=5434 user=postgres'));--clients
select dblink.dblink_connect('session2' ,concat('dbname=',current_database(),' port=5434 user=postgres'));--DBA
---start trick:---
select dblink.dblink_exec('session1' ,'INSERT into public.old_table (fld) 
								select concat (g::text,''::'',timestamp''now'')
								from generate_series(1,3) g;')
		
from generate_series(0,100) g
where g<>50 or 'OK'=(dblink.dblink_exec('session2' ,'ALTER TABLE old_table RENAME TO old_table_old;
								ALTER TABLE new_table RENAME TO old_table;'
								))

;
-----/trick----------
--chck;---
SELECT * FROM ONLY old_table;
SELECT * FROM ONLY old_table_old;
SELECT tableoid::regclass::text, * FROM /*ONLY*/ old_table order by t_id;
update old_table set fld= fld ||fld WHERE t_id<10; 
SELECT tableoid::regclass::text, * FROM /*ONLY*/ old_table order by t_id;