|
With the files should came metadata to describe what is inside the file. I can't put in the comment options because is not ISO standart that allow to produce metadata.
I'm rookie with Postgre what do you mean by "stored in a text field of a table"? comment option? If exist one option in the table options called "Metadata" would be great because allow to insert all the information there. Best R. JS > Date: Tue, 14 Aug 2012 03:09:16 -0700 > From: pierce@xxxxxxxxxxxx > To: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: Add Metadata to Postgre SQL > > On 08/14/12 2:55 AM, José Pedro Santos wrote: > > Not comments. In comments i can't use the ISO that rules Metadata XML. > > Basically put XML Metadata files inside the schemas. Is possible? > > not sure what the International Standards Organization has to do with > this, but XML is just text, and can be stored in a text field of a > table, or better yet, decompose the XML to whatever data it contains, > and store that data in separate fields in your table of metadata. > > > > -- > john r pierce N 37, W 122 > santa cruz ca mid-left coast > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general |
