Re: Prepared statements with bind parameters for DDL

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