Re: Tool to compare db schemas? - Mailing list pgsql-admin

From CoL
Subject Re: Tool to compare db schemas?
Date
Msg-id c7abuq$3qf$1@news.hub.org
Whole thread Raw
In response to Tool to compare db schemas?  ("Chris Hoover" <revoohc@sermonaudio.com>)
List pgsql-admin
hi,

Chris Hoover wrote:

> Does anyone know of a good tool to compare db schemas?  I have over 200 db's
> that should all have identical schemas and have been asked to report on the
> differences.

if you looking for a program, check
http://ems-hitech.com/pgsqlutils/index.phtml#pgcomparer

but you can write your own scripts to compare schemas, even in plpgsql
too with different servers (using dblink)

C.

pgsql-admin by date:

Previous
From: "Richard Colman"
Date:
Subject: Limiting user access to a view only
Next
From: Ludek Finstrle
Date:
Subject: initdb: FATAL: conversion between LATIN2 and UNICODE