Don't waste your time figuring out what modifications your database requires. Let pgdiff do the work for you!
As an example, consider a project where you have a SQL schema in a source code repository, a test server and a production server. By using pgdiff, you can guarantee that your database changes are migrated properly from source to test, and from test to production. By solving this problem programmatically, the chance for human error is greatly reduced.