ViewTube

Welcome back to our PostgreSQL Professional series! In this video, we're diving into the world of custom functions. Learn how to ...

Discover why using `PL/pgSQL` can lead to slower execution times compared to raw `SQL` queries in PostgreSQL. Learn how to ...

Master SQL - Learn modern SQL with PostgreSQL with this popular, formerly paid course, now completely FREE. Over 150 ...

Welcome to this PostgreSQL One Shot Full Course where you will master SQL database in just 5 hours with real-time case studies ...

Discover how to create a PL/PGSQL function to return multiple rows dynamically using JSON. Learn how to handle `GROUP BY` ...

A step-by-step guide on how to return multiple values, including a cursor and a list of student names, from a single PostgreSQL ...

Learn how to execute an `Anonymous Block PL/pgSQL` using Npgsql in C# . We provide a step-by-step solution to avoid common ...

Welcome back to Dev Portal. In this tutorial, we dive deep into Stored Procedures in PostgreSQL, covering: - The difference ...

Learn how to use dynamic SQL in PL/pgSQL to add values to an existing enum type in PostgreSQL without encountering syntax ...

Learn how to effectively return multiple rows from a PL/PgSQL function in Postgres 14.7, utilizing loops and proper syntax to build ...

How to Fix Relation Does Not Exist Error in PostgreSQL PL/pgSQL Function? In this video tutorial, you will learn how to resolve ...

Learn how to effectively query a custom datatype within an array in PL/pgSQL, avoiding common pitfalls and improving ...