Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] Postgres schema comparison. - Mailing list pgsql-sql

From Markus Schaber
Subject Re: [ADMIN] Postgres schema comparison.
Date
Msg-id 422C51DC.5050408@logix-tt.com
Whole thread Raw
In response to Re: [ADMIN] Postgres schema comparison.  (Stef <svb@ucs.co.za>)
Responses Re: [ADMIN] Postgres schema comparison.  (Stef <svb@ucs.co.za>)
List pgsql-sql
Tree view 
Hi, Stef,

Stef schrieb:

> The problem I have with this, is that I have to run the command per table,
> and seeing that I have over 500 tables in each database, this takes quite a
> long time.

Some weeks ago, I posted here a script that uses psql to create split
dumps. Maybe you can reuse some of its logics to create per-table
md5sums for all tables in a database automatically.

Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
Attachment

pgsql-sql by date:

Previous
From: Richard_D_Levine@raytheon.com
Date:
Subject: Re: [ADMIN] Postgres schema comparison.
Next
From: Stef
Date:
Subject: Re: [ADMIN] Postgres schema comparison.