Обсуждение: file in posgres
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??
I also need to convert the data of a tble into XML???
I need all this in order to work with PDF files.
Thanks
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
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 troublewith the bytea data type that I use to store files. Can't you tell if there is any problem with that and if not howdo 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
What do you mean with this???????
binary data in XML needs to be uuencoded afaik,
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
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 <alainrod@gmail.com> wrote:
What do you mean with this???????binary data in XML needs to be uuencoded afaik,
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
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