Re: Database Instance Creation via Java/JDBC

On Mon, 2003-02-17 at 11:10, Carl Olivier wrote:
> Greetings.
>
> I posted a question to this list a couple of days ago, but maybe it
> got lost ;)
>
> Anyway, what I am trying to find out is whether it is possible to
> remotely interact with a POSTGRSQL database server over JDBC from
> within Java code to perform the following operations:
>
> 1.  Create and initialise a new database instance entirely (files,
> caching, etc)

Use CREATE DATABASE (see create_database(7l)).

> 2.  Retrieve a list of databases as well as their current states
> 3.  Delete (drop) a specified database instance entirely

DROP DATABASE (drop_database(7l))

> 4.  Change the state of a specified database instance (from offline to
> running etc)
> 5.  Any additional information retrieval possbile would also be great.
>
> If anyone has ANY information (even negative) I would really
> appreciate it!
>
> Thank you in advance,
>
> Carl Olivier
> Director
> tel  +27 21 7955197
> fax +27 21 7955212
> cell +27 82 7729753

See the documentation for PostgreSQL SQL commands, and use
statement.execute(...)

--
Daniel Serodio <daniel@checkforte.com.br>
CheckForte