| From: | Tino Wildenhain <tino(at)wildenhain(dot)de> |
|---|---|
| To: | Bjørn T Johansen <btj(at)havleik(dot)no> |
| Cc: | rod(at)iol(dot)ie, PostgreSQL general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How can I compare sql create script with running database? |
| Date: | 2008-06-05 13:28:55 |
| Message-ID: | 4847EA17.4000608@wildenhain.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
Bjørn T Johansen wrote:
> On Thu, 05 Jun 2008 11:06:36 +0100
> Raymond O'Donnell <rod(at)iol(dot)ie> wrote:
>
>> On 05/06/2008 10:52, Bjørn T Johansen wrote:
>>> If I already have a running database, how can I compare the tables in
>>> the database with the sql script to discover the differences?
>> You can use pg_dump with the -s option to dump the schema of the
>> database, and run it through the diff tool of your choice.
>>
>> Ray.
>>
>
> Well, not really an option because I don't think the dump will be an exact match to the sql script....
>
Unless you create all your objects with your script into a different
Database on the server then use pg_dump -s on both and compare the
result :-)
Cheers
Tino
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gary Fu | 2008-06-05 14:08:25 | Re: how to clean up temporary schemas (how to sync the system table with pg_dump) |
| Previous Message | Ioannis Tambouras | 2008-06-05 13:25:38 | Re: functions, transactions, key violations |