Re: file in posgres - Mailing list pgsql-admin

On Thu, Dec 22, 2005 at 07:30:56AM -0800, Alain Rodriguez Arias wrote:
> 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!!!!!

Can you post the first portion of the suspected bad XML?


> > What do you mean with this???????
> >  *binary data in XML needs to be uuencoded afaik,*

XML only allows data within a certain range of values. I'm pretty sure
that you can't just stick raw binary data into XML without ensuring that
it won't contain certain invalid characters, and the most common way to
do that is to base-64 (or uuencode) it.

man uuencode on a unix/linux/OS X box should provide more info.

> >  On 12/19/05, Jim Nasby <jnasby@pervasive.com> 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 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
> > > into an XML format, and I'm afraid to have any trouble with the bytea data
> > > 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 <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 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
> > >
> >
> >

--
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