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