| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, "Alex J(dot) Avriette" <alex(at)posixnap(dot)net> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Mark Lubratt <mark(dot)lubratt(at)indeq(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [ADMIN] Schema comparisons |
| Date: | 2004-03-03 08:14:31 |
| Message-ID: | 200403030814.31396.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-hackers |
On Wednesday 03 March 2004 03:44, Christopher Kings-Lynne wrote:
> > I recently had to figure out what was different between the "live" schema
> > and the schema in cvs at work. This was a really painful process, and it
> > occurred to me that it wouldn't be terribly hard to write a perl program
> > to do it (I wound up using vim and diff). Is there interest in such a
> > tool? I could probably have one written within a day or two.
>
> Someone wrote a utility called 'pgdiff' that generated the SQL commands
> necessary to transform on db in to another IIRC.
I think it was started, but didn't reach completion (if we're thinking about
the same thing).
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | DHS Webmaster | 2004-03-03 17:19:17 | bizarre AGE behaviour |
| Previous Message | Bruce Momjian | 2004-03-03 05:16:57 | Re: un-CLUSTER? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Bartunov | 2004-03-03 09:40:00 | Re: docs on tsearch2 |
| Previous Message | Tom Lane | 2004-03-03 05:36:38 | Re: [HACKERS] Tablespaces |