Re: SQL Sessions and the DROP DATABASE command

Hey.

Thanks for the reply, although not what I wanted to hear ;)

damn!

so you mean that I cannot do this except on the actual machine or via a
shell script with sufficient permissions?!?!

Carl

-----Original Message-----
From: Dave Cramer [mailto:Dave(at)micro-automation(dot)net]
Sent: 06 March 2003 03:34 PM
To: carl(at)zero-one(dot)co(dot)za
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] 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(at)micro-automation(dot)net>