Thread: Postgre and XML

Hi,

   I´m interested in running xml with postgre. I use postgre version 8.2 and windows xp. I would like to know how can i enable the xml in the postgresql.
    Did you know if its secure to use this xml function of postgre in commercial applications? How much trustable its this module? Can anyone explain me how to install the xml module?

Thanks for the help.

Am Montag, 19. November 2007 schrieb x asasaxax:
>    I´m interested in running xml with postgre. I use postgre version 8.2
> and windows xp. I would like to know how can i enable the xml in the
> postgresql.

That depends on what you want to do with it.  XML is quite a broad topic.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

Peter Eisentraut wrote:
> Am Montag, 19. November 2007 schrieb x asasaxax:
> >    I?m interested in running xml with postgre. I use postgre version 8.2
> > and windows xp. I would like to know how can i enable the xml in the
> > postgresql.
>
> That depends on what you want to do with it.  XML is quite a broad topic.

Here is our Postgres 8.2 documentation about XML:

    http://www.postgresql.org/docs/8.2/static/datatype-xml.html

Postgres 8.3 has some new XML features:

    http://www.postgresql.org/docs/8.3/static/release-8-3.html

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

I dont know how can i enable the xml in postgre. I´ve tried to do a xml search function but it seams that the postgre doesen´t recognized the function. How can I install and use the xml on the postgre?

Thanks

x asasaxax escribió:
> I dont know how can i enable the xml in postgre. I´ve tried to do a xml
> search function but it seams that the postgre doesen´t recognized the
> function. How can I install and use the xml on the postgre?

What version of Postgres?  In Postgres 8.2 and earlier, you need to
install a Postgres contrib module.  In Postgres 8.3 (currently in beta),
you need to rebuild Postgres with --with-libxml to enable the internal
Postgres XML functionality.


Note to Postgres people: do we think that repetition will cause the
correct name to stick?

--
Alvaro Herrera                  http://www.amazon.com/gp/registry/5ZYLFMCVHXC
"La gente vulgar solo piensa en pasar el tiempo;
el que tiene talento, en aprovecharlo"

x asasaxax wrote on 19.11.2007 12:17:
> Hi,
>
>    I´m interested in running xml with postgre. I use postgre version 8.2 and
> windows xp. I would like to know how can i enable the xml in the postgresql.
>
>     Did you know if its secure to use this xml function of postgre in
> commercial applications? How much trustable its this module? Can anyone
> explain me how to install the xml module?
>
> Thanks for the help.
>
The Postgres Windows installer will ask you if you want to install (and enable)
the XML module (at least it did for me)

But I have no clue how you would enable the module after the installation has
finished.

Regards
Thomas

On 19/11/2007 21:44, Thomas Kellerer wrote:

> But I have no clue how you would enable the module after the
> installation has finished.

I think you have to run an SQL script to enable the module.

Ray.


---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------

On 19/11/2007 22:05, Raymond O'Donnell wrote:
> On 19/11/2007 21:44, Thomas Kellerer wrote:
>
>> But I have no clue how you would enable the module after the
>> installation has finished.
>
> I think you have to run an SQL script to enable the module.

Sorry, that wasn't very helpful. :-) I should have said that there's
usually an SQL script that comes with the particular module, which you
need to run against your database to enable the module.

On my XP laptop, a peek into

   C:\Program Files\PostgreSQL\8.2\share\contrib

reveals files named pgxml.sql and uninstall_pgxml.sql which ought to do
the job.

A further peek into

   C:\Program Files\PostgreSQL\8.2\doc\contrib

reveals a whole bunch of README files, one for each contrib module, with
detailed instructions and other good stuff.

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------