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 96C4A9DCC70 for ; Wed, 21 Dec 2005 22:10:33 -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 65994-09 for ; Wed, 21 Dec 2005 22:10:36 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.205]) by postgresql.org (Postfix) with ESMTP id 0CC0E9DCBBF for ; Wed, 21 Dec 2005 22:10:30 -0400 (AST) Received: by wproxy.gmail.com with SMTP id 57so259811wri for ; Wed, 21 Dec 2005 18:10:35 -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=FN74+t2smdat8Jqijr86ww2OxfFdH8IDLTz61BiZcoize7/2d17mAQF5AIxIBFUOxdoZUg0IhWiOTo5a5kq3W2T/C1m+TAvGh2AIlIOuHE+tMHlVRCLrfZX8eO2Nwxo/EFERvp3oPxyksSBExACEStAAnBjllKzAbDxM44LRMQ8= Received: by 10.54.96.2 with SMTP id t2mr1233337wrb; Wed, 21 Dec 2005 18:10:35 -0800 (PST) Received: by 10.54.126.15 with HTTP; Wed, 21 Dec 2005 18:10:35 -0800 (PST) Message-ID: <526cb99d0512211810m61c3ee07l8e9e2f887d11bd35@mail.gmail.com> Date: Wed, 21 Dec 2005 18:10:35 -0800 From: Alain Rodriguez Arias To: Jim Nasby Subject: Re: file in posgres Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_22475_1866179.1135217435008" References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200512/261 X-Sequence-Number: 19981 ------=_Part_22475_1866179.1135217435008 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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'l= l > want to put it in a CDATA block. > > PostgreSQL doesn't have any XML support built-in, but there's at least on= e > project that has stuff to help deal with XML. I think it's in pgFoundry, > 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 int= o > an XML format, and I'm afraid to have any trouble with the bytea data typ= e > that I use to store files. Can't you tell if there is any problem with t= hat > 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 any > 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 XML > 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_22475_1866179.1135217435008 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
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:
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.

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-----
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 mi= ssunderstood me, i need to export all the data of a table into an XML forma= t, and I'm afraid to have any trouble with the bytea data type that I use t= o 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 <jnasby@pervasive.com> wrote:
On Sat, Dec 17, 2005 at 02:45= :08PM -0800, Alain Rodriguez Arias wrote:
> Hi everybody:
> I n= eed that somebody tell me if there is any way to save a file of any kind
> in a field of a database in posgres??

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

> I also need to&nb= sp; convert the data of a tble into  XML???

No reason to do that in the database... though if you end up storin= g XML
you should just stick it in a text field.
--
Jim C. Nasby, S= r. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 5= 12-231-6117
vcard: http:/= /jim.nasby.net/pervasive.vcf       cell: = 512-569-9461

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

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

------=_Part_22475_1866179.1135217435008--