Simple CRON entry with a script that runs a psql command
alter table rename
create table x as select * from original table.
Depending on you DDL needs or permissions/setup
From: Rajesh Kumar <rajeshkumar.dba09@xxxxxxxxx>
What is the best way to rename the table name automatically every 30 minutes?