Yup, works like a charm. Thanks Salah and Tom for the advise ! -dave -----Original Message----- From: Tom Lane [mailto:[email protected]] Sent: Wednesday, August 29, 2012 11:18 AM To: Gauthier, Dave Cc: [email protected] Subject: Re: [GENERAL] using vars in ddl in procedure call
"Gauthier, Dave" <[email protected]> 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 -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
