Postgres Pro
Downloads
Home   >   mailing lists

Re: using vars in ddl in procedure call - Mailing list pgsql-general

From Tom Lane
Subject Re: using vars in ddl in procedure call
Date
Msg-id 10405.1346253486@sss.pgh.pa.us
Whole thread Raw
In response to using vars in ddl in procedure call  ("Gauthier, Dave" <dave.gauthier@intel.com>)
Responses Re: using vars in ddl in procedure call  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
Tree view 
"Gauthier, Dave" <dave.gauthier@intel.com> writes:
> Trying (failing) a test to see if I can run ddl in a procedure where elements of the ddl are vars.  Consider...

You'll need to construct the command as a string value and then run it
with EXECUTE.  Beware of quoting issues (quote_ident and quote_literal
are your friends).

            regards, tom lane

pgsql-general by date:

Previous
From: salah jubeh
Date:
Subject: Re: using vars in ddl in procedure call
Next
From: Andres Freund
Date:
Subject: Re: [postgis-users] pg_dump -s should use add_geometrycolumn(...)