100% Free
🎯 3200+ Questions. One Goal: Your Success Sign In Sign Up

What is the difference between a function and a stored procedure in PostgreSQL?

Junior PostgreSQL

Answer

Functions return values and can be used in queries, while procedures do not return values and can manage transactions.
Bookmark Add to Set Notes

Want to bookmark, take notes, or join discussions?

Sign in to access all features and personalize your learning experience.

Sign In Create Account

Source: SugharaIQ

Related Questions in PostgreSQL

(10 questions)
What is PostgreSQL?
What is a database cluster in PostgreSQL?
What is a schema in PostgreSQL?
What is the difference between a table and a view?
What is a primary key in PostgreSQL?
What is a foreign key?
What data types does PostgreSQL support?
What is the purpose of the SELECT statement?
What is the WHERE clause used for?
What is ORDER BY in PostgreSQL?
View All PostgreSQL Questions
Ready to level up? Start Practice