On Mon, 2006-10-02 at 22:56 -0700, pd wrote:
> guys,
>
> is there a way to run various programs like (pg_config, pg_restore,
> dropdb etc) from within pgadmin or from within my java code. i mean can
> i perform database administration from within postgres that is without
> using literal commands. so from within my java code i can execute a
> query like select all etc. but can i also execute a query which will
> perform database administration.
>
> i mean when my java code says "select all" it doesnt have psql in front
> of it. so why when i have to backup or do anything else i need to use
> pg_dump and not a general query (which really makes things very
> complicate programmatically).
>
First of all, some administration can be easily performed with queries,
such as CREATE DATABASE, DROP DATABASE, CREATE LANGUAGE, etc.
To work with something like pg_dump, just open a pipe. Generally you
want to output to a file anyway. It would be odd to have something like
a pg_dump api call that dumped information out as a Java string. If
nothing else, you might not be able to store the entire string in
memory, so the interface of unix pipes is much better.
Regards,
Jeff Davis