Displaying the progress of DDL commands is a work-in-progress in Postgres. Some things already work, and others are in the works; I describe what exists today and what we can get in the future. I also explain how it works, so you can implement it for your favorite DDL for fun and profit.
--
Álvaro Herrera - Álvaro has been developing PostgreSQL for a decade and a half. In his lifetime he has got many features in almost all major versions since 7.2, and plans to continue doing so, as long as there are people to share database war stories over beers. His knowledge of the database internals has allowed him to recover many corrupted databases, and plans never to do that again... though plans fail as frequently as users forget to take backups.