In simple terms, PostgreSQL extensions are packages that add extra functionality to your database (just like we are adding plugins to VSCode/Sublime). This could be anything from additional data types, functions, index types, or even entire procedura...
