Presented by:


Jim Mlodgenski

from Amazon Web Services

Principal database engineer at Amazon Web Services, Co-Chair - PostgresConf US, Director - United States PostgreSQL, Co-organizer of Philly PUG & NYC PUG, former CTO at OpenSCG, former Chief Architect at EnterpriseDB

No video of the event yet, sorry!

Note: No slides/videos available for trainings.

When developing against a PostgreSQL database, many times you will use SQL from your applications, but sometimes you need more. You might need to run some of your logic on the database server for performance or you may want to just create some server-side functions to simplify your application development. There is an infinite number of reasons why you would want to write some code that runs on the PostgreSQL server and PostgreSQL has a rich set of options when you want to do that, but most times, you will use PL/pgSQL. The primary objective of this tutorial is to introduce you to the PostgreSQL PL/pgSQL programming language and to give you the practical skills to be a productive developer working with PostgreSQL databases.

In the course of this tutorial, you will be introduced to a variety of fundamental PL/pgSQL functions like: * How to declare and use PL/SQL Variables * How to create functions and procedures * How to write triggers * Handle run time errors

And much more...

2020 February 26 - 14:00
3 h 30 min
Robusta + Arabica
PGConf India, 2020

Happening at the same time:

  1. PostGIS - A DBA and Developer view
  2. Start Time:
    2020 February 26 14:00

    Grand Victoria 1

  3. Architecting operational real-time analytics apps with PostgreSQL & Hyperscale (Citus)
  4. Start Time:
    2020 February 26 14:00

    Grand Victoria 2