pgsql structure export to XML

On 29. Feb, 19:28 h., abracadabuda <abracadab...@gmail.com> 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)

Thanks a lot

--
abracadabuda

i've just find something just right on postgresql 8.3, i will try
it :)
see http://www.postgresql.org/docs/current/interactive/functions-xml.html

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&gt;

Thomas

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

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...&gt;

Thomas

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

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