Re: Add Metadata to Postgre SQL

Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx> · Tue, 14 Aug 2012 07:54:11 -0700



    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