Carl,
This is not possible through the jdbc interface.
Dave
On Thu, 2003-03-06 at 04:25, Carl Olivier wrote:
> Greetings.
>
> I need to be able to call the DROP DATABASE database command via JDBC.
>
> Unfortunately I need to kill off any active connections to the
> specified database before the DROP DATABASE command will work.
>
> Is there anyway from within a JDBC connection to say the template1
> database as the superuser on a POSTGRESQL server to:
>
> 1. Determine what connections are open and active to a specified
> database
> 2. Kill ALL these sessions.
>
> Thank you in advance,
>
> Carl Olivier
--
Dave Cramer <Dave(at)micro-automation(dot)net>