Postgres Pro
Downloads
Home   >   mailing lists

Re: comparison schema/data - Mailing list pgsql-admin

From Gezeala M. Bacuño II
Subject Re: comparison schema/data
Date
Msg-id CAJKO3mVrJGMwDydnxMeHuLsFLUrSs=v4L+=4gT-SQPKRJP6LAQ@mail.gmail.com
Whole thread Raw
In response to comparison schema/data  (Javier Urbano Contreras <javier.urbano.contreras@gmail.com>)
List pgsql-admin
Tree view



On Wed, Jul 17, 2013 at 8:00 AM, Javier Urbano Contreras <javier.urbano.contreras@gmail.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.

pgsql-admin by date:

Previous
From: CS DBA
Date:
Subject: Re: Help with PITR in PostgreSQL 8.4
Next
From: Mag Gam
Date:
Subject: Re: Mag Gam