I've very roughly (first time I've tried anything but hello world c) hacked up inline comments.
pg_dump -I
Exports the comments generated through COMMENT ON in an appropriate manner (line above) the item with a -- in front. More or less a self documenting dump, or atleast an attempt at it.
However, due to my poor programming in this language, I'm not sure of teh best way to handle the issues following:
- Column comments mis-format the next row (Needs a \t or something)
- Database comments non-existent, wasn't sure how or where to pull them out.
- I've only tested TABLE and COLUMN comments. Didn't have a database handy with the rest, and had a limited amount of time to fiddle.
Take a look and see if it's worth anything or if it needs to be fixed up.
--
Rod Taylor
There are always four sides to every story: your side, their side, the truth, and what really happened.