| From: | bricklen <bricklen(at)gmail(dot)com> |
|---|---|
| To: | Prashanth Adiyodi <Prashantha(at)celltick(dot)com> |
| Cc: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: Where clause in pg_dump: need help |
| Date: | 2016-07-07 16:10:02 |
| Message-ID: | CAGrpgQ_WA20_or3Nw1Rw8h8jCczHnJyrevv7+tu7BbCoEbsaOQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-general |
On Thu, Jul 7, 2016 at 7:06 AM, Prashanth Adiyodi <Prashantha(at)celltick(dot)com>
wrote:
> I am working on a script where I need to take backup of certain tables (or
> a database) using the “*date_trunc('day', NOW() - interval '1 month');*”
> as a where clause.
>
As others have pointed out, pg_dump doesn't have a facility to apply
filters to the dump. However, there is a tool called pg_sample that allows
you to export subsets. https://github.com/mla/pg_sample
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oskari Saarenmaa | 2016-07-07 19:43:59 | Re: BUG #14150: Attempted to delete invisible tuple |
| Previous Message | Francisco Olarte | 2016-07-07 15:12:41 | Re: Where clause in pg_dump: need help |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2016-07-07 16:23:27 | Re: Fastest memmove in C |
| Previous Message | Francisco Olarte | 2016-07-07 15:12:41 | Re: Where clause in pg_dump: need help |