X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id A84389DC815 for ; Thu, 22 Dec 2005 11:31:00 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 04160-03 for ; Thu, 22 Dec 2005 11:30:58 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.192]) by postgresql.org (Postfix) with ESMTP id 1B0DE9DCCB7 for ; Thu, 22 Dec 2005 11:30:51 -0400 (AST) Received: by wproxy.gmail.com with SMTP id 57so361921wri for ; Thu, 22 Dec 2005 07:30:57 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=lNdr5zxJ3cTMq1PaeuL+tFOxyvrIug7il/mJzsYueynYqDJ7qPovPXs001NH6Xlj6/HPvXrAb1mzm8wRZfa4AJsZyKD3d36CnDhVjImmrpLaAjnMboiKPuQ0UutZOUiON4zBuE9CQcdMqTiKHgTElk5Rt/lVaZEeiSCYZZmsmhA= Received: by 10.54.127.10 with SMTP id z10mr2385497wrc; Thu, 22 Dec 2005 07:30:56 -0800 (PST) Received: by 10.54.126.15 with HTTP; Thu, 22 Dec 2005 07:30:56 -0800 (PST) Message-ID: <526cb99d0512220730i8a62b99l2122f371d3eaf08a@mail.gmail.com> Date: Thu, 22 Dec 2005 07:30:56 -0800 From: Alain Rodriguez Arias To: Jim Nasby Subject: Re: file in posgres Cc: pgsql-admin@postgresql.org In-Reply-To: <526cb99d0512211810m61c3ee07l8e9e2f887d11bd35@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4260_8501105.1135265456686" References: <526cb99d0512211810m61c3ee07l8e9e2f887d11bd35@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.061 required=5 tests=[AWL=0.060, HTML_MESSAGE=0.001] X-Spam-Score: 0.061 X-Spam-Level: X-Archive-Number: 200512/274 X-Sequence-Number: 19994 ------=_Part_4260_8501105.1135265456686 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Ok I'm using the EMS PostgreSQL Manager Pro utility to export my data into = a XML, the thing is that when I got a bytea field, which i use to save files, when i tried to import the XML I have just create the file is corrupt. I believe it has something to do with the XML encoding I'using or something like that??? Any help please. The bytea field I'm using it to save PDF file!!!!! On 12/21/05, Alain Rodriguez Arias wrote: > > What do you mean with this??????? > *binary data in XML needs to be uuencoded afaik,* > > > On 12/19/05, Jim Nasby wrote: > > > > Including -admin back in the discussion... > > > > Well, binary data in XML needs to be uuencoded afaik, and of course > > you'll want to put it in a CDATA block. > > > > PostgreSQL doesn't have any XML support built-in, but there's at least > > one project that has stuff to help deal with XML. I think it's in pgFou= ndry, > > though there may be some stuff in contrib as well. > > > > -----Original Message----- > > From: Alain Rodriguez Arias [mailto:alainrod@gmail.com] > > Sent: Monday, December 19, 2005 3:10 PM > > To: Jim Nasby > > Subject: Re: [ADMIN] file in posgres > > > > > > Naybe you missunderstood me, i need to export all the data of a table > > into an XML format, and I'm afraid to have any trouble with the bytea d= ata > > type that I use to store files. Can't you tell if there is any problem= with > > that and if not how do I do the export to XML??? > > > > > > On 12/19/05, Jim C. Nasby wrote: > > On Sat, Dec 17, 2005 at 02:45:08PM -0800, Alain Rodriguez Arias wrote: > > > Hi everybody: > > > I need that somebody tell me if there is any way to save a file of an= y > > kind > > > in a field of a database in posgres?? > > > > http://www.postgresql.org/docs/8.1/static/datatype-binary.html > > > > > I also need to convert the data of a tble into XML??? > > > > No reason to do that in the database... though if you end up storing XM= L > > you should just stick it in a text field. > > -- > > Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com > > Pervasive Software http://pervasive.com work: 512-231-6117 > > vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 > > > > ---------------------------(end of broadcast)--------------------------= - > > TIP 4: Have you searched our list archives? > > > > http://archives.postgresql.org > > > > ------=_Part_4260_8501105.1135265456686 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
Ok I'm using the EMS PostgreSQL Manager Pro utility to export my data = into a XML, the thing is that when I got a bytea field, which i use to save= files, when i tried to import the XML I have just create the file is = corrupt.=20
I believe it has something to do with the XML encoding I'using or some= thing like that???
Any help please.
The bytea field I'm using it to save PDF file!!!!!

 
On 12/21/05, Alain Rodriguez Arias <alainr= od@gmail.com> wrote:
What do you mean with this???????
 binary data in XML needs to be u= uencoded afaik,

 
On 12/19/05, Jim Nasby <jnasby@pervasive= .com > wrote:=20
Including -admin back in the dis= cussion...

Well, binary data in XML needs to be uuencoded afaik, and= of course you'll want to put it in a CDATA block.=20

PostgreSQL doesn't have any XML support built-in, but there's at le= ast one project that has stuff to help deal with XML. I think it's in pgFou= ndry, though there may be some stuff in contrib as well.

-----Origin= al Message-----=20
From: Alain Rodriguez Arias [mailto:alainrod@gmail.com]
Sent: Monday, December 19, 2005 3:10 PM
To= : Jim Nasby
Subject: Re: [ADMIN] file in posgres


Naybe you missunderstoo= d me, i need to export all the data of a table into an XML format, and I'm = afraid to have any trouble with the bytea data type that I use to store fil= es.  Can't you tell if there is any problem with that and if not = how do I do the export to XML???=20


On 12/19/05, Jim C. Nasby <jnasby@pervasive.com> wrote:
On Sat, Dec 17, 2005 at 02:45= :08PM -0800, Alain Rodriguez Arias wrote:
> Hi everybody:
> I need that somebody tell me if there is any= way to save a file of any kind
> in a field of a database in posgre= s??

http://www.postgresql.org/docs/8.1/static/datatype-binary.html

&= gt; I also need to  convert the data of a tble into  XM= L???

No reason to do that in the database... though if you end up s= toring XML
you should just stick it in a text field.
--
Jim C. Nasby, Sr. Engineering Consultant    &= nbsp; jnasby@pervasive.com
Pervasive Software      
http://pervasive.com    work: 512-231-6117
vcard= : http://jim.nasby.net/perva= sive.vcf       cell: 512-569-9461=20

---------------------------(end of broadcast)----------------------= -----
TIP 4: Have you searched our list archives?

  &nb= sp;            http://archives.postgresql.org

=

------=_Part_4260_8501105.1135265456686--