On Fri, 2009-03-27 at 10:44 -0500, Dara Olson wrote: > I am new to postgres/postgis and am trying to figure out the best way > to approach documenting metadata within postgres. Has there been > anything developed to add FGDC or Dublin Core standard metadata > records into postgres for each table within the database? Is there > any program that can access postgres to insert metadata based on a > standard or any other way to document metadata for a postgres > database? Any help, suggestions or advice from prior experiences > would be greatly appreciated.
The only way we have of adding additional metadata onto an object is via the COMMENT command, which accepts a text string as input. You can fill that with metadata as much as you like - the system never touches that information other than to store it. So you can put an XML fragment with Dublin Core tags in there etc. I think your suggestion that we should have a/another field to store structured metadata about objects is a good one. It would certainly encourage better documentation in-database. Perhaps as an additional XML column. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
