Re: SQL Sessions and the DROP DATABASE command

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@micro-automation.net>