Simple CRON entry with a script that runs a psql command
You can:
alter table rename
Or
create table x as select * from original table.
Depending on you DDL needs or permissions/setup
From: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
Sent: Wednesday, August 9, 2023 1:39 PM
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: [EXTERNAL] Automate to rename table
Hi friends,
What is the best way to rename the table name automatically every 30 minutes?