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