Re: Difference in schema



EN wrote:

I'm looking for software which might give me difference
between schema two databases in Postgresql.
The main purpose is catch difference between production and development db.


Although I know nothing of Postgresql, I was going to make a sarcastic response along the lines of

dbschema -d db1 > db1.schema
dbschema -d db2 > db2.schema
diff db1.schema db2.schema

And then I discovered http://www.thescripts.com/forum/thread420807.html

.



Relevant Pages

  • Difference in schema
    ... between schema two databases in Postgresql. ... The main purpose is catch difference between production and development db. ...
    (comp.lang.java.databases)
  • Re: Need your help [arguments for open source databases]
    ... >> I would like to have your opinions about open source databases versus ... >> in the universe of relational databases. ... The main difference between PostgreSQL and Oracle is manageability. ...
    (RedHat)
  • Re: postgres to mysql
    ... Ich meine, Du willst auf ein System replizieren, ... Dort gibt es ein Kapitel "Converting from other Databases to PostgreSQL" ...
    (de.comp.datenbanken.mysql)
  • Re: Database similar to MS Access for LInux?
    ... >> the application and they are run sequentially and the total time taken ... > Look at mySql and postgresql. ... > databases can be accessed from almost all programming languages, ... Besides VBA, I use ...
    (alt.os.linux)
  • Re: [PHP] Re: Getting last record ID created from DB
    ... There in lies the biggest problem with LAMP, and that's MySQL. ... They use PostgreSQL and we do have a auto incremented unique id ... but rather a sequence value. ... I guess maybe most databases support the notion of "auto number" in some ...
    (php.general)