Postgres Pro
Downloads
Home   >   mailing lists

Thread: pgsql structure export to XML

pgsql structure export to XML

From
abracadabuda
Date:
Hi,

i need to export pgsql structure of tables, vies, PK, FK etc. etc.
into simple XML structure.

My 3 hour searching ended with one result: postgresql-autodoc, but i
don't have enough rights on server to install it.

Is there any solution for my problem - is there any program (best
under Win)?

I can make my own export, but i want to avoid it. (not enough time)

Thanks a lot

--
abracadabuda

Re: pgsql structure export to XML

From
Thomas Kellerer
Date:
abracadabuda wrote on 29.02.2008 19:28:
> Hi,
>
> i need to export pgsql structure of tables, vies, PK, FK etc. etc.
> into simple XML structure.
>
> My 3 hour searching ended with one result: postgresql-autodoc, but i
> don't have enough rights on server to install it.
>
> Is there any solution for my problem - is there any program (best
> under Win)?

You can try my SQL Workbench/J.

The WbReport command is what you are looking for:
<http://www.sql-workbench.net/manual/wb-commands.html#command-schema-report>

Thomas

Re: pgsql structure export to XML

From
brian
Date:
abracadabuda wrote:
> Hi,
>
> i need to export pgsql structure of tables, vies, PK, FK etc. etc.
> into simple XML structure.
>
> My 3 hour searching ended with one result: postgresql-autodoc, but i
> don't have enough rights on server to install it.
>
> Is there any solution for my problem - is there any program (best
> under Win)?
>
> I can make my own export, but i want to avoid it. (not enough time)
>

You can use postgresql-autodoc against a remote server.

b

Re: pgsql structure export to XML

From
abracadabuda
Date:
On 29. Feb, 22:55 h., spam_ea...@gmx.net (Thomas Kellerer) wrote:
> abracadabuda wrote on 29.02.2008 19:28:
>
> > Hi,
>
> > i need to export pgsql structure of tables, vies, PK, FK etc. etc.
> > into simple XML structure.
>
> > My 3 hour searching ended with one result: postgresql-autodoc, but i
> > don't have enough rights on server to install it.
>
> > Is there any solution for my problem - is there any program (best
> > under Win)?
>
> You can try my SQL Workbench/J.
>
> The WbReport command is what you are looking for:
> <http://www.sql-workbench.net/manual/wb-commands.html#command-schema-r...>
>
> Thomas
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster


Thanks a lot, this is the solution i was looking for :)
--
abracadabuda