Better late then never - Stored Procedures in PG 11
Presented by:
Ahsan Hadi
Ahsan is a database evangelist with over 20 years of development and management experience, he is very passionate about databases and has worked with has worked with Postgres & Oracle extensively through out his career. With over 15 years of working with PostgreSQL, he has worked with companies like EDB as a Senior Director of Product Development , HighGo Software as VP of Development and Analyst Programmer with British Telecom. Ahsan is currently working as Director Support & Services with pgEdge, pgEdge is fully distributed PostgreSQL DB, optimized for the network edge and deployable across multiple cloud regions or data centers.
No video of the event yet, sorry!
Finally we have stroed procedures in PostgreSQL 11, better late then never. PostgreSQL versions prior to 11 only supported functions, the support for stored procedures was added in PostgreSQL 11. It is added as a new schema object which is similar to functions and but without a return value and with some subtle differneces and benefits.
The main benefits of Stored procedure are the following : - list text herelist text hereTransaction control for allowing commit and rollback inside procedures - list text hereMaking Oracle to PostgrSQL migration easier, the stored procedure usuage is very popular in Oracle - list text hereStored functions and procedure are mostly similar so it is easy for end-users
The talk will provide a detailed insight into using Stored Procedure with PG 11, how to create procedure, how to use procedures and how to execute procedures using different connectors and languages. While stored procedure aren't suppose to have a return value, we will get into how we can use them to get return values. In this talk you will learn the usuage of in and inout parameters with stored procedure and how to get return values from stored procedures using Java and C program. We will also go through some examples of how to migrate stored procedures from Oracle into Stored procedures in PostgreSQL. One key benefit of stored procedure is transaction control, we will run through use cases and example of doing transaction control and using commit and rollback.
- Date:
- 2020 November 19 14:10 CST
- Duration:
- 40 min
- Room:
- Virtual - English Sub-Conference A
- Conference:
- CHINA 2020 And PGConf.Asia 2020
- Language:
- Track:
- Everything about Postgres
- Difficulty:
- Medium