Re: JDBC + PL/pgSQL ?

Dear Dave and JDBC people,

Hi, I must apologize for not being entirely clear (truth is, I hit
Ctrl+Enter in Outlook before I was finished typing).
What I mean is; is it possible to create a Statement from a String
which contains PL/pgSQL code, and then execute that Statement. Thus, the
PL/pgSQL procedure is not stored in the database, but is being called
through the JDBC connection.
I know that in Oracle you can do this with their PL/SQL code, I was
just wondering if the PostgreSQL JDBC driver also supports this.
Thanks for your help. Sorry for the incomplete e-mail the first
time.

Sincerely,

Daryl.

> -----Original Message-----
> From: Dave Cramer [mailto:Dave(at)micro-automation(dot)net]
> Sent: Wednesday, June 26, 2002 4:54 PM
> To: Daryl Beattie
> Cc: pgsql-jdbc(at)postgresql(dot)org
> Subject: Re: [JDBC] JDBC + PL/pgSQL ?
>
>
> Daryl,
>
> Yes, just do a select procedurename();
>
> Dave
> On Wed, 2002-06-26 at 13:43, Daryl Beattie wrote:
> > Dear JDBC people,
> >
> > I have a very simple question; is it possible to write
> a PL/pgSQL
> > procedure and execute it through JDBC's Statement.execute()
> method? Thanks
> > for your time. :)
> >
> >
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to
> majordomo(at)postgresql(dot)org
> >
> >
> >
>
>
>