Re: PoC: pg_dump --filter-data <file> (like Oracle Where Clause on RMAN for specific tables)

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: Kirk Wolak <wolakk(at)gmail(dot)com>
Cc: Greg Sabino Mullane <htamfids(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, Nikolay Samokhvalov <nik(at)postgres(dot)ai>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Pavlo Golub <Pavlo(dot)Golub(at)cybertec(dot)at>
Subject: Re: PoC: pg_dump --filter-data <file> (like Oracle Where Clause on RMAN for specific tables)
Date: 2025-08-23 15:04:42
Message-ID: CACJufxEAZPJBT_Jm-8Cr9ZACnmpSXn7A_KVJri9B+o0OSSUGbA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

hi.

I just found this
https://www.postgresql.org/message-id/flat/CALAY4q8o00Sg5nemi2AuqNuLvmGLaR6br%2BYrvM41ZuSPjM2Qvg%40mail.gmail.com
maybe it's not that very helpful.

IMV,
pg_dump --option="view_name"
is better than
pg_dump -d cary --where="test1:a3 = ( select max(aa1) from test2 )" > testdump2

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2025-08-23 15:23:21 Re: List TAP test files in makefiles
Previous Message Peter Eisentraut 2025-08-23 14:57:53 Re: Remove unneeded cast in heap_xlog_lock.