| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Stef <svb(at)ucs(dot)co(dot)za> |
| Cc: | Markus Schaber <schabi(at)logix-tt(dot)com>, pgsql-ADMIN(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: [SQL] Postgres schema comparison. |
| Date: | 2005-03-07 14:30:53 |
| Message-ID: | 22961.1110205853@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
Stef <svb(at)ucs(dot)co(dot)za> writes:
> Markus Schaber mentioned :
> => But maybe a pg_dump --schema-only on all the databases, and then
> => manually diffing the files may already fulfil your needs.
> I've tested something similar, that seems to work ok for me for now :
> pg_dump -s -t [TABLE] [DBNAME] | grep -v "^--" | md5sum
> The problem I have with this, is that I have to run the command per table,
Why?
If the problem is varying order of table declarations, try 8.0's
pg_dump.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-03-07 14:35:44 | Re: Build from file syntax troublem (part II). |
| Previous Message | Tom Lane | 2005-03-07 14:26:11 | Re: Help on maintaining pgsql/data folder size |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gary Stainburn | 2005-03-07 14:44:31 | Re: simple update from select ?? |
| Previous Message | Stef | 2005-03-07 13:40:51 | Re: [SQL] Postgres schema comparison. |