I'm working with vector but is like that. I just add a new column them I will copy the XML file into their..let me see if work.
Thanks, Best R. JP > Date: Tue, 14 Aug 2012 04:52:30 -0700 > From: pierce@xxxxxxxxxxxx > To: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: Add Metadata to Postgre SQL > > On 08/14/12 4:32 AM, José Pedro Santos wrote: > > 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. > > > > you have a table with your data stored in it, right? something like... > > create table myrasters (id serial, rasterdata bytea); ? > > well, add another text field, metadata, like... > > alter table myrasters add column metadata text; > > and store your metadata there. > > > > -- > 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 |