From: | Daniel Serodio <daniel(at)checkforte(dot)com(dot)br> |
---|---|
To: | carl(at)zero-one(dot)co(dot)za |
Cc: | PostgreSQL JDBC List <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Database Instance Creation via Java/JDBC |
Date: | 2003-02-18 13:54:00 |
Message-ID: | 1045576439.3679.44.camel@kelly.ckf |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-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(at)checkforte(dot)com(dot)br>
CheckForte
From | Date | Subject | |
---|---|---|---|
Next Message | Barry Lind | 2003-02-18 16:44:04 | Re: DataSource suddenly drops all connections? |
Previous Message | Holger Klawitter | 2003-02-18 13:07:43 | DataSource suddenly drops all connections? |