PostgreSQL: schema diff/patch tool Consider the following setting:


A production DB
A dev db, on which schema changes are made to enable new features


When the development of a new feature is complete, I have to manually update the prod db schema until pg_dump --schema-only on both DBs is identical. This process is error prone and tedious.

So, I am looking for a tool that can:


Show a summary of the differences between two schemas (like diff). Note that I am not looking for a mere textual diff of the schema, but a more elaborate tool that can draw conclusions like "Table X has a new column Y".
Auto-generate the SQL code that would convert one schema to another (like patch)


Is there a schema diff/patch tool that can help me convert prod schemas to the more advanced dev schemas?
Sorry to resurrect an old question

Recently I have been using the 0xDBE DataGrip Database management tool by JetBrains. 

It supports multiple database engines, in the excellent Jetbrains IDE, and a key feature I have found useful is the ability to diff 2 tables (DEV and PROD). 

Below is a screenshot of the diff in action (in this case there is only one column difference). The screenshot is the result of the "Merge Right" button at the top, generating the SQL required to bring the right table up to scratch.



Hope this new tool helps.