Re: Add Metadata to Postgre SQL - Mailing list pgsql-general

From José Pedro Santos
Subject Re: Add Metadata to Postgre SQL
Date
Msg-id BLU162-W13FCAF8FBE69685768ACD3E0B70@phx.gbl
Whole thread Raw
In response to Re: Add Metadata to Postgre SQL  (John R Pierce <pierce@hogranch.com>)
Responses Re: Add Metadata to Postgre SQL  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
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@hogranch.com
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] 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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Add Metadata to Postgre SQL
Next
From: Dmitriy Igrishin
Date:
Subject: Determining a table column by the view column.