How to make a copy of trigger function in postgreSQL pgadmin 4?

Question

I am using postgreSQL with pgAdmin 4 and I have created a database function named "fn_test1()". I want to delete this function and before delete this function, I want to create a backup function named "fn_test1_bk()" . Can anyone help me to do this?

It is really a shame that people spend all that time writing documentation that no one bothers to read. Alter Function. ALTER FUNCTION name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] RENAME TO new_name. There is even an example at bottom of page. Kills two birds with one stone. — Adrian Klaver
– Adrian Klaver, Commented Aug 31, 2022 at 23:43

JGH · Accepted Answer · 2022-09-01 13:42:59Z

1

If you really want to use PgAdmin for this, you can browse to your function, right click, properties, change the name and save.

answered Sep 1, 2022 at 13:42

JGH

18.2k5 gold badges40 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to make a copy of trigger function in postgreSQL pgadmin 4?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related