Re: metadata as XML

mesued wrote:
> Dear group:
>
> I've a XML formatted data about quality information of my existing
> tables in pg database. Hence, I want to store it onto my pg database
> as a table and link it with respective existing table. Secondly,
> later, I've to call it from the client (browser) side to enable users
> get access to the XML data (to help users read the metadata
> information about each table)


so, you want a table with (tablename text, xml_metadata xml) ?

browsers should under no conditions be connecting directly to your
database, so presumably you'd have a function on the webserver side to
fetch and pass this data back to the client browser.


it seems to me that this metadata is redundant with the information that
can be extractd from information_.schema.tables, ,columns, etc and
perhaps it would be better to have this web service function build your
XML metadata on the fly from the information_schema rather than manually
storing it seperately in its own table, as this way the returned data
will always be accurate.