Hi Daryl,
I don't know of a way to execute PL/pgSQL code without creating a PL/pgSQL function.
But you can create a function through the JDBC connection using Statement.execute("create function ....")
Joachim
Daryl Beattie wrote:
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@micro-automation.net]
Sent: Wednesday, June 26, 2002 4:54 PM
To: Daryl Beattie
Cc: pgsql-jdbc@postgresql.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@postgresql.org
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html