Обсуждение: pgAdmin and XML

I have data saved as xml. Can pgAdmin use xml as a
data source, if so how? If not, how can I achieve
integration with outside data?

I've used an app called Navicat that works great, but
I can't afford it yet. So I'm looking for another
solution.

Thoughts? Suggestions?

thx


j

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Is there no gui that goes with pgxml2? Are there any
other gui solutions?

--- Shoaib Mir <shoaibmir@gmail.com> wrote:

> Try using xml2 contrib module (
>
http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/xml2/)
> for
> PostgreSQL.
>
> Thanks,
> --
> Shoaib Mir
> EnterpriseDB (www.enterprisedb.com)
>
> On 7/29/06, julian howard <julianhwrd@yahoo.com>
> wrote:
> >
> > I have data saved as xml. Can pgAdmin use xml as a
> > data source, if so how? If not, how can I achieve
> > integration with outside data?
> >
> > I've used an app called Navicat that works great,
> but
> > I can't afford it yet. So I'm looking for another
> > solution.
> >
> > Thoughts? Suggestions?
> >
> > thx
> >
> >
> > j
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam?  Yahoo! Mail has the best spam
> protection around
> > http://mail.yahoo.com
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 9: In versions below 8.0, the planner will
> ignore your desire to
> >        choose an index scan if your joining
> column's datatypes do not
> >        match
> >
>


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

> > On 7/29/06, julian howard <julianhwrd@yahoo.com>
> > wrote:
> > > I have data saved as xml. Can pgAdmin use xml as a
> > > data source, if so how? If not, how can I achieve
> > > integration with outside data?

There are lots of modules in the Perl world (at CPAN) which can
help in moving data from one format to another, or into a
database.  They all involve writing a little bit of code in perl
however.

DBIx::Admin::BackupRestore would be my first guess as a module to
look at.

Gord

I'll take a look at it, thanks. Your thoughts on
navicat postgre?

j

--- Gordon Haverland <ghaverla@shaw.ca> wrote:

> > > On 7/29/06, julian howard <julianhwrd@yahoo.com>
> > > wrote:
> > > > I have data saved as xml. Can pgAdmin use xml
> as a
> > > > data source, if so how? If not, how can I
> achieve
> > > > integration with outside data?
>
> There are lots of modules in the Perl world (at
> CPAN) which can
> help in moving data from one format to another, or
> into a
> database.  They all involve writing a little bit of
> code in perl
> however.
>
> DBIx::Admin::BackupRestore would be my first guess
> as a module to
> look at.
>
> Gord
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend
>


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com