Automate to rename table

From: "Wetmore, Matthew (CTR)" <Matthew(dot)Wetmore(at)express-scripts(dot)com>
To: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Automate to rename table
Date: 2023-08-09 20:49:48
Message-ID: a4aa1ded524e423ca3ebbd0fea723315@express-scripts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joseph Hammerman 2023-08-09 21:55:07 Tracking the dirty tuple read rate
Previous Message Rajesh Kumar 2023-08-09 20:38:41 Automate to rename table