| From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
|---|---|
| To: | José Pedro Santos <zpsantos1(at)hotmail(dot)com> |
| Cc: | pierce(at)hogranch(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Add Metadata to Postgre SQL |
| Date: | 2012-08-14 14:54:11 |
| Message-ID: | 502A6693.4080108@pinpointresearch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zdeněk Bělehrádek | 2012-08-14 15:07:01 | Re: Visualize database schema |
| Previous Message | Dmitriy Igrishin | 2012-08-14 14:18:43 | Determining a table column by the view column. |