| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Mark Lubratt <mark(dot)lubratt(at)indeq(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Schema comparisons |
| Date: | 2004-02-28 04:28:25 |
| Message-ID: | 25377.1077942505@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-hackers |
Mark Lubratt <mark(dot)lubratt(at)indeq(dot)com> writes:
> I've been trying to be careful, but I've gotten out of synch with
> whether or not I've applied the changes I've made to the development
> system to the production system. Is there a utility that will compare
> the tables, functions, trigger, views, etc. between two systems and
> flag the schema elements that aren't in synch between the two?
Have you tried diffing pg_dump output? It's not the greatest tool but
it's helpful.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tsirkin Evgeny | 2004-02-28 12:18:45 | Re: copying data between tables |
| Previous Message | Mark Lubratt | 2004-02-28 03:32:43 | Schema comparisons |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2004-02-28 08:40:27 | Re: Thread safe connection-name mapping in ECPG. Is it |
| Previous Message | elein | 2004-02-28 04:14:16 | Re: [pgsql-www] Collaboration Tool Proposal |