How to implement Transactions (COMMIT, ROLLBACK, SavePoint) in PostgreSQL.

In this video, I will show you how to use Transactions in PostgreSQL. All the source code is available in my GitHub Account.

https://github.com/softwareNuggets/Po...

Learn how the Commit and Rollback transactions to your database.
Learn how to use SavePoints, Rollback to SavePoint and Release Savepoint.
Lastly, how to use the function pg_backend_pid() and pg_terminate_backend(pid) to kill processes.

Table of Contents
00:00 Hey Team
00:11 github - how to use
00:40 Overview - lesson I will teach in this video
01:50 - create table HR_Employee
02:56 - how to use commit statement
05:29 - how to use rollback statement
06:47 - how to use savepoints, rollback to savepoint and release savepoint
11:34 - how to kill a PID, pg_backend_pid(), pg_terminate_backend(pid)
14:17 - Table Locks, how to kill PID
16:21 - Closing Message

‪@SoftwareNuggets‬ , #softwareNuggets , Transactions, pg_backend_pid(), pg_terminate_backend(pid), Commit, Rollback, SavePoint
#share_to_be_better