Обсуждение: pgsql structure export to XML
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
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
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...> > > Thomas > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster Thanks a lot, this is the solution i was looking for :) -- abracadabuda