Postgres Pro
Downloads
Home   >   mailing lists

Re: Automate to rename table - Mailing list pgsql-admin

From Wells Oliver
Subject Re: Automate to rename table
Date
Msg-id CAOC+FBWEV2FtkGLjZHsEjKHki5WL0VSiBJhymdkny1JHHfggPQ@mail.gmail.com
Whole thread Raw
In response to Automate to rename table  ("Wetmore, Matthew (CTR)" <Matthew.Wetmore@express-scripts.com>)
Responses Re: Automate to rename table  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
List pgsql-admin
Tree view
Wild. What's the use-case here?

On Wed, Aug 9, 2023 at 9:50 PM Wetmore, Matthew (CTR) <Matthew.Wetmore@express-scripts.com> wrote:

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@gmail.com>
Sent: Wednesday, August 9, 2023 1:39 PM
To: pgsql-admin@lists.postgresql.org
Subject: [EXTERNAL] Automate to rename table

 

Hi friends,

 

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

 



--

pgsql-admin by date:

Previous
From: Rajesh Kumar
Date:
Subject: Undo Update
Next
From: Holger Jakobs
Date:
Subject: Re: Undo Update