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

From Steve Crawford
Subject Re: Add Metadata to Postgre SQL
Date
Msg-id 502A6693.4080108@pinpointresearch.com
Whole thread Raw
In response to Re: Add Metadata to Postgre SQL  (José Pedro Santos <zpsantos1@hotmail.com>)
List pgsql-general
On 08/14/2012 06:34 AM, José Pedro Santos wrote:
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.

You can store XML in a text field but if the data is truly well-formed XML you may be better off defining the column as XML to take advantage of the operations available on that data type:

http://www.postgresql.org/docs/current/static/datatype-xml.html
http://www.postgresql.org/docs/current/static/functions-xml.html

Cheers,
Steve


pgsql-general by date:

Previous
From: Dmitriy Igrishin
Date:
Subject: Determining a table column by the view column.
Next
From: Zdeněk Bělehrádek
Date:
Subject: Re: Visualize database schema