Re: Prepared statements with bind parameters for DDL - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Prepared statements with bind parameters for DDL
Date
Msg-id 54DB9733.7000404@aklaver.com
Whole thread Raw
In response to Prepared statements with bind parameters for DDL  (deepak <deepak.pn@gmail.com>)
List pgsql-general
On 02/11/2015 09:42 AM, deepak wrote:
> Hi,
>
> I find that one can't have a prepared statement with bind parameters for
> a DDL statement,
> although I couldn't find the rationale for this restriction.  Is this
> limitation due to the database
> design, or is it something that's imposed by the SQL standard and/or the
> JDBC drivers?
>
> Please clarify.

That is going to require a lot more information:

What Postgres version?

Where exactly are you preparing the statement?

Since you mention JDBC, are we to assume that is what you are using?

Can we see an example of what you are trying to do?

Have you looked at?:

http://www.postgresql.org/docs/9.3/static/functions-string.html#FUNCTIONS-STRING-FORMAT

>
>
> --
> Deepak


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: deepak
Date:
Subject: Prepared statements with bind parameters for DDL
Next
From: Tom Lane
Date:
Subject: Re: Prepared statements with bind parameters for DDL