plpgsql function-parsing - Mailing list pgsql-general

From chris
Subject plpgsql function-parsing
Date
Msg-id d24066d1-a3b6-89a2-bb20-beaa92f98405@pgsqlrocket.com
Whole thread Raw
Responses Re: plpgsql function-parsing  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
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


I'm looking into parsing the string but i can't find a way to parse in a 
way that'll work. Any ideas?


Thanks,

Chris



pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: What is wrong with my pgadmin?
Next
From: Celia McInnis
Date:
Subject: normalizing a float array?