Re: pg_dump limit 1000 rows

From: bricklen <bricklen(at)gmail(dot)com>
To: "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg_dump limit 1000 rows
Date: 2016-03-03 01:04:24
Message-ID: CAGrpgQ8shRKgV1zkN01+R+O5akXMcAgYmCS79TqPxgSOvR7BMQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Mar 2, 2016 at 4:56 PM, drum(dot)lucas(at)gmail(dot)com <drum(dot)lucas(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message drum.lucas@gmail.com 2016-03-03 02:44:50 Re: pg_dump limit 1000 rows
Previous Message drum.lucas@gmail.com 2016-03-03 00:56:12 pg_dump limit 1000 rows