2012/8/14 José Pedro Santos <zpsantos1@hotmail.com>:
> 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.
there is nice goulash :)
you are using terms that has different meaning in GIS and in database
theory probably.
You can create own tables and you can store any text or binary content
to these tables.
Probably PostGIS mailing list
http://postgis.refractions.net/mailman/listinfo/postgis-users will be
probably better for you
Nice a day
Pavel Stehule
>
> Best R.
> JS
>
>> Date: Tue, 14 Aug 2012 03:09:16 -0700
>> From: pierce@hogranch.com
>> To: pgsql-general@postgresql.org
>> Subject: Re: [GENERAL] 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@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general