Re: How can I compare sql create script with running database?

Hi,

Bjørn T Johansen wrote:
> On Thu, 05 Jun 2008 11:06:36 +0100
> Raymond O'Donnell <rod@iol.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