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.
|
BEGIN:VCARD VERSION:2.1 N:Taylor;Rod;B FN:Taylor, Rod B ORG:BarChord Entertainment Inc.;System Operation and Development TITLE:Chief Technical Officer ADR;WORK:;;;Toronto;Ontario;;Canada LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Toronto, Ontario=0D=0ACanada X-WAB-GENDER:2 URL: URL:http://www.barchord.com BDAY:19790401 EMAIL;INTERNET:[EMAIL PROTECTED] EMAIL;PREF;INTERNET:[EMAIL PROTECTED] EMAIL;INTERNET:[EMAIL PROTECTED] REV:20001221T173310Z END:VCARD