Re: plpgsql function-parsing

2018-03-06 Thread Pavel Stehule
Hi 2018-03-06 16:51 GMT+01:00 chris : > Hi, > > I am trying to create a function that gets passed a statement as a string > and then I need to change the table_name within the string by adding a > "_cdc" to it, then execute the statement > > ex: > > string passed could be GRANT all ON authors TO

plpgsql function-parsing

2018-03-06 Thread chris
Hi, I am trying to create a function that gets passed a statement as a string and then I need to change the table_name within the string by adding a "_cdc" to it, then execute the statement ex: string passed could be GRANT all ON authors TO bob. then EXECUTE GRANT all ON authors_cdc TO bob