ViewTube

ViewTube
Sign inSign upSubscriptions
Filters

Upload date

Type

Duration

Sort by

Features

Reset

632 results

The Debug Zone
PostgreSQL PL/pgSQL: How to Use Variable Column Names in Queries

In this video, we dive into the powerful capabilities of PL/pgSQL in PostgreSQL, focusing on the use of variable column names in ...

2:39
PostgreSQL PL/pgSQL: How to Use Variable Column Names in Queries

10 views

4 months ago

vlogize
How to Copy Data with Relationships in PostgreSQL Using PL/pgSQL

Learn how to effectively copy data between tables in PostgreSQL, maintaining relationships through foreign keys, using a ...

2:27
How to Copy Data with Relationships in PostgreSQL Using PL/pgSQL

1 view

9 months ago

vlogize
How to Create a Stored Procedure in PostgreSQL that Returns a Table Result Set

Learn how to effectively create a `stored procedure` in PostgreSQL that returns a table result set using the appropriate SQL ...

1:46
How to Create a Stored Procedure in PostgreSQL that Returns a Table Result Set

149 views

9 months ago

vlogize
Why the Performance of PL/pgSQL is Slower Than SQL in PostgreSQL Functions

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

1:55
Why the Performance of PL/pgSQL is Slower Than SQL in PostgreSQL Functions

11 views

7 months ago

Rob Emanuele
Metrics Copilot in the VS Code PostgreSQL extension
3:47
Metrics Copilot in the VS Code PostgreSQL extension

298 views

2 months ago

vlogize
How to Dynamically Add Values to a PostgreSQL Enum in PL/pgSQL

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

1:35
How to Dynamically Add Values to a PostgreSQL Enum in PL/pgSQL

8 views

9 months ago

vlogize
How to Ignore All PGSQL Comments in Diff While Comparing Schema Files

This guide covers how to use `awk` to ignore PGSQL comments when using the diff command to compare schema files in ...

1:30
How to Ignore All PGSQL Comments in Diff While Comparing Schema Files

0 views

4 months ago

Andrés Montenegro
Data-Cube: Fixing Monthly Supply Metric Stored Procedure in PostgreSQL (PL/pgSQL)
3:11
Data-Cube: Fixing Monthly Supply Metric Stored Procedure in PostgreSQL (PL/pgSQL)

4 views

4 months ago

vlogize
How to Use Array Variables in My SQL Statement in PL/pgSQL

Learn how to effectively use array variables in your SQL statements with PL/pgSQL, simplifying your `SELECT... WHERE IN` ...

1:31
How to Use Array Variables in My SQL Statement in PL/pgSQL

0 views

5 months ago

vlogize
How to Return Multiple Rows from a PL/PGSQL Function Using Dynamic Queries in PostgreSQL

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

2:26
How to Return Multiple Rows from a PL/PGSQL Function Using Dynamic Queries in PostgreSQL

10 views

9 months ago

vlogize
Understanding pl/pgsql Block Code Support in postgres-nodejs

Learn how to implement `pl/pgsql` block code in node.js with PostgreSQL to efficiently manage database transactions using ...

1:35
Understanding pl/pgsql Block Code Support in postgres-nodejs

0 views

9 months ago

vlogize
How to Return Multiple Values from One Function in PostgreSQL sql plpgsql

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

2:20
How to Return Multiple Values from One Function in PostgreSQL sql plpgsql

16 views

9 months ago

vlogize
Discovering the Most Repeated Coordinate in PgSQL

Learn how to effectively find the highest occurrence of point type data within a specified range in PostgreSQL. Optimize your data ...

1:31
Discovering the Most Repeated Coordinate in PgSQL

0 views

3 months ago

vlogommentary
Resolving "Query Has No Destination for Result Data" Error in PL/pgSQL Functions

Learn how to modify your PL/pgSQL function in PostgreSQL to avoid the common "query has no destination for result data" error.

3:22
Resolving "Query Has No Destination for Result Data" Error in PL/pgSQL Functions

9 views

10 months ago

vlogize
Mastering the DECLARE Statement in PL/pgSQL: Solving Common Errors

Discover effective solutions to the `ERROR: query has no destination for result data` issue in PL/pgSQL functions and improve ...

2:40
Mastering the DECLARE Statement in PL/pgSQL: Solving Common Errors

1 view

9 months ago

vlogize
Solving the Issue of Using pgsql-http to Store Values in PostgreSQL Triggers

Discover the solution to the issue of not storing values in a PostgreSQL trigger when using pgsql-http for API calls. Learn best ...

2:26
Solving the Issue of Using pgsql-http to Store Values in PostgreSQL Triggers

10 views

9 months ago

vlogize
Solving Beginner SQL Errors: Using Update in PL/pgSQL Correctly

Learn how to properly implement the `UPDATE` statement in PL/pgSQL and overcome common syntax errors. This guide is ...

2:20
Solving Beginner SQL Errors: Using Update in PL/pgSQL Correctly

0 views

4 months ago

vlogize
Solving PostgreSQL Errors: Dynamic Table Structure Updates in PL/pgSQL Functions

Discover how to update table structures in PostgreSQL and access them within PL/pgSQL functions without encountering ...

2:31
Solving PostgreSQL Errors: Dynamic Table Structure Updates in PL/pgSQL Functions

2 views

10 months ago

vlogize
How to Call a PL/pgSQL Function in PostgreSQL Without Errors

Learn how to correctly call a PL/pgSQL function in PostgreSQL and avoid common pitfalls related to query result handling.

1:40
How to Call a PL/pgSQL Function in PostgreSQL Without Errors

10 views

8 months ago

CodeMake
declare a variable in a postgresql query

Get Free GPT4.1 from https://codegive.com/04c3cca ## Declaring and Using Variables in PostgreSQL Queries: A Comprehensive ...

0:54
declare a variable in a postgresql query

5 views

6 months ago