Automate to rename table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


Simple CRON entry with a script that runs a psql command


You can:


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>
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?


[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux