Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump limit 1000 rows - Mailing list pgsql-admin

From bricklen
Subject Re: pg_dump limit 1000 rows
Date
Msg-id CAGrpgQ8shRKgV1zkN01+R+O5akXMcAgYmCS79TqPxgSOvR7BMQ@mail.gmail.com
Whole thread Raw
In response to pg_dump limit 1000 rows  ("drum.lucas@gmail.com" <drum.lucas@gmail.com>)
Responses Re: pg_dump limit 1000 rows  ("drum.lucas@gmail.com" <drum.lucas@gmail.com>)
List pgsql-admin
Tree view


On Wed, Mar 2, 2016 at 4:56 PM, drum.lucas@gmail.com <drum.lucas@gmail.com> wrote:
I wanna do a minimal dump DB file. (I'm using PostgreSQL 9.2)
So I was thinking about getting the last 1000 rows data from some tables....

Have a look at pg_sample, it should do exactly what you are looking to do.
https://github.com/mla/pg_sample

pgsql-admin by date:

Previous
From: "drum.lucas@gmail.com"
Date:
Subject: pg_dump limit 1000 rows
Next
From: "drum.lucas@gmail.com"
Date:
Subject: Re: pg_dump limit 1000 rows