Thank you Albe.. Could u plz suggest me the best way to get the definition of functions via connecting through psql as while I am trying to change the definition through \ef function_name it won't reflect the changes.
Thanks Brajendra On Wed, 9 Sep, 2020, 7:39 PM Laurenz Albe, <laurenz.a...@cybertec.at> wrote: > On Wed, 2020-09-09 at 17:04 +0530, Brajendra Pratap Singh wrote: > > Recently we had renamed schema and role but it will not get reflect in > the object definitions ,plz suggest. > > > > OLD SCHEMA/ROLE - TEST11 > > NEW SCHEMA/ROLE - TEST > > > > But still we are that TEST11 is present in the definition of sone > objects like procudure,functions,triggers etc, so how can we modify the > name from TEST11 to TEST in definition. > > > > You cannot habe that automatically. > > While in view and index definitions as well as column default clauses, > the internal object identifier is used, so that renaming doesn't break > anything, functions are stored as string literals and parsed at > execution time. > > You'll have to edit all your functions (or undo the renaming). > > Yours, > Laurenz Albe > -- > Cybertec | https://www.cybertec-postgresql.com > >
