Re: Automate to rename table

Wild. What's the use-case here?

On Wed, Aug 9, 2023 at 9:50 PM Wetmore, Matthew (CTR) <
Matthew(dot)Wetmore(at)express-scripts(dot)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(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?
>
>
>

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>