PostgreSQL: Copy/import a user defined function from one database to another database

Question

I have a similar question like this, but for PostgreSQL. I am using PostgreSQL 9.5.12 (x64) on my Windows 10 (x64) machine. I have a function (written in plpgsql) my_func() in database my_db. Is it possible to import/copy this function to another database in postgres?

Jasen · Accepted Answer · 2018-06-03 21:35:59Z

4

In psql the \ef command will open the function in an editor you can then save it to a file... unfortunately the UI of the windows version of psql was pretty cruddy last time I checked.

a pg_dump of the database with --schema-only will also include all function definitions. you can then open it in an editor and copy the functions.

edited Jun 3, 2018 at 21:35

answered Jun 3, 2018 at 8:07

Jasen

12.5k2 gold badges37 silver badges50 bronze badges

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

Comments

Michel Milezzi · Accepted Answer · 2018-06-01 15:41:06Z

3

You could use pg_get_functiondef to get function definition as follows:

SELECT pg_get_functiondef(oid) AS definition FROM pg_proc WHERE proname = 'my_func';

answered Jun 1, 2018 at 15:41

Michel Milezzi

11.4k3 gold badges24 silver badges36 bronze badges

Collectives™ on Stack Overflow

PostgreSQL: Copy/import a user defined function from one database to another database

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related