Automate to rename table

["Wetmore, Matthew (CTR)" <Matthew.Wetmore@xxxxxxxxxxxxxxxxxxx>]

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.dba09@xxxxxxxxx>
Sent: Wednesday, August 9, 2023 1:39 PM
To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx
Subject: [EXTERNAL] Automate to rename table

 

Hi friends,

 

What is the best way to rename the table name automatically every 30 minutes?