How to list procedures in PostgreSQL database
Aug 07th, 2021,In this article, you will learn several ways to list all procedures and user-defined functions in a PostgreSQL database.
1. Using SQL Query
To show all procedures and user-defined functions in a PostgreSQL database, you can use the following SQL query:
SELECT nspname, proname FROM pg_catalog.pg_namespace JOIN pg_catalog.pg_proc ON pronamespace = pg_namespace.oid WHERE nspname = 'public' ORDER BY Proname
Sample results
3. Using ERBuilder Data Modeler
In addition to the SQL query and psql methods, with ERBuilder Data Modeler you can also visualize all stored procedures in your PostgreSQL database.
ERBuilder Data Modeler allows you to view the procedure or the function defining script which you can edit as well as it allows you to create a new procedure or function and you can also delete needless ones. All that is just by double-clicking on the function or procedure name.
How ERBuilder Helps
ERBuilder Data Modeler is a GUI data modeling tool that allows you to visualize, design and model databases by using entity relationship diagrams and automatically generates the most popular SQL databases including Amazon Redshift. Generate and share the data Model documentation with your team. Optimize your data model by using advanced features such as test data generation, schema compare and schema synchronization. Try now ERBuilder for 15 days FREE
Subscribe To Our Newsletter
Subscribe to our email newsletter today to receive updates of the latest news, tutorials and special offers!
