When writing my DDL statements I like to document them with javadoc inspired comments. The "pgcomment" tool will convert those comments into "COMMENT" SQL statements, so the comments are present inside PostgreSQL. Optionally you can convert the javadoc to LaTeX or HTML.