On Thu, Jul 7, 2016 at 7:06 AM, Prashanth Adiyodi <Prashantha@celltick.com>
wrote:
> I am working on a script where I need to take backup of certain tables (o=
r
> a database) using the =E2=80=9C*date_trunc('day', NOW() - interval '1 mon=
th');*=E2=80=9D
> 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