Postgres Pro
Downloads
Home   >   mailing lists

Truncate data from whole cluster - Mailing list pgsql-admin

From Rajesh Kumar
Subject Truncate data from whole cluster
Date
Msg-id CAJk5Atah42SXmNFDJmP22XtTeov+aKfSSkzCAAqXYzMe0En-8A@mail.gmail.com
Whole thread Raw
Responses Re: Truncate data from whole cluster
List pgsql-admin
Tree view
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?


pgsql-admin by date:

Previous
From: SOzcn
Date:
Subject: Re: Timestamps in outputs
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Truncate data from whole cluster