Re: how to store whole XML file in database

From: Tommy Gildseth <tommy(at)gildseth(dot)com>
To: deepak pal <deepak(dot)05pal(at)gmail(dot)com>
Cc: PostgreSQL - General <pgsql-general(at)postgresql(dot)org>
Subject: Re: how to store whole XML file in database
Date: 2007-02-12 18:09:52
Message-ID: 45D0AD70.8060403@gildseth.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

deepak pal wrote:
> hi,,
> i have to insert whole xml file in database ,there is a text
> field for that.but it shows error parse error where there are
> attribute ..plz help me out.

I'm guessing you have a quoting problem. Try escaping the XML-data
before inserting it into the database, so that any single quotes doesn't
mess up your insert statements.

--
Tommy

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew J. Kopciuch 2007-02-12 18:31:06 Re: Service startup - troubleshooting
Previous Message Ian Harding 2007-02-12 17:36:37 Re: Adjacency List or Nested Sets to model file system hierarchy?