Re: comparison schema/data

From: Gezeala M(dot) Bacuño II <gezeala(at)gmail(dot)com>
To: Javier Urbano Contreras <javier(dot)urbano(dot)contreras(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: comparison schema/data
Date: 2013-07-18 16:19:55
Message-ID: CAJKO3mVrJGMwDydnxMeHuLsFLUrSs=v4L+=4gT-SQPKRJP6LAQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Jul 17, 2013 at 8:00 AM, Javier Urbano Contreras <
javier(dot)urbano(dot)contreras(at)gmail(dot)com> wrote:

> Does anyone any tool in command line for comparison schema/data?
>

You can write a simple script for this. For DATA, pg_dump -a (data only)
the tables then use "sort" then "diff". For Schema, that's easier, just do
a "diff" on a schema only dump.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mag Gam 2013-07-21 06:23:58 Re: Mag Gam
Previous Message CS DBA 2013-07-18 13:20:03 Re: Help with PITR in PostgreSQL 8.4