I have undertaken a
project which causes me to want to store XML in Pg. I want to store and retrieve
it and convert to HTML (actually, XHTML) either as a function of storing it or
on the fly (probably the latter) via XSL. Are there any conventions that people
use for this? Like, what does the table look like (varchar(?) or text?). I've
looked at the contrib directories in Pg and the xml2 looks like it assumes that
it is already stored. The xml drectory says that it is deprecated. Any pointers
would be helpful.
John
Mohr
