Truncate data from whole cluster

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

To: Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: Truncate data from whole cluster
From: Rajesh Kumar <rajeshkumar.dba09@xxxxxxxxx>
Date: Wed, 20 Dec 2023 14:35:52 +0530

Hi all,

I am using postgres 15.2. one leader and one replica. I have multiple dbs and multiple tables. I want to keep definitions and only want to delete 'data only' from all dbs and tables.

Any command to do that instead of truncating all tables one by one?

Follow-Ups:
- Re: Truncate data from whole cluster
  - From: hubert depesz lubaczewski

Prev by Date: Re: Timestamps in outputs
Next by Date: Re: Truncate data from whole cluster
Previous by thread: Timestamps in outputs
Next by thread: Re: Truncate data from whole cluster
Index(es):
- Date
- Thread

[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