Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Foundation - Pl\pgsql

Avatar for Deepak Mahto Deepak Mahto
June 17, 2024
Technology
0
220

Foundation - Pl\pgsql

Webinar on Foundation - Procedural Development with PostgreSQL.

Highlight importance on development near data, PL\pgSQL Internals.
Avatar for Deepak Mahto

Deepak Mahto

June 17, 2024
Tweet

More Decks by Deepak Mahto

See All by Deepak Mahto
What's New in PostgreSQL 17 for Developer.
Avatar for Deepak Mahto deepakmahto
0
98
Accelerating PL/pgSQL Code Conversion When Migrating to Postgres
Avatar for Deepak Mahto deepakmahto
0
180
Optimizing Numeric Data Types in Oracle to PostgreSQL Migration
Avatar for Deepak Mahto deepakmahto
0
86

Other Decks in Technology

See All in Technology
Кто отправит outbox? Валентин Удальцов, автор канала Пых
Avatar for Lamoda Tech lamodatech
0
240
25分で解説する「最小権限の原則」を実現するための AWS「ポリシー」大全 / 20250625-aws-summit-aws-policy
Avatar for opelab opelab
6
590
新卒3年目の後悔 〜機械学習モデルジョブの運用を頑張った話〜
Avatar for camay kameitomohiro
0
360
生成AIでwebアプリケーションを作ってみた
Avatar for tajimon tajimon
2
120
BrainPadプログラミングコンテスト記念LT会2025_社内イベント&問題解説
Avatar for BrainPad brainpadpr
0
120
AIエージェントの継続的改善のためオブザーバビリティ
Avatar for PharmaX（旧YOJO Technologies）開発チーム pharma_x_tech
6
1.4k
強化されたAmazon Location Serviceによる新機能と開発者体験
Avatar for Yasunori Kirimoto dayjournal
1
110
AWS アーキテクチャ作図入門/aws-architecture-diagram-101
Avatar for Kohei "Max" MATSUSHITA ma2shita
28
9.3k
JSX - 歴史を振り返り、⾯⽩がって、エモくなろう
Avatar for 晴れ井戸 pal4de
3
1k
Prox Industries株式会社 会社紹介資料
Avatar for Prox proxindustries
0
140
OTFSG勉強会 / Introduction to the History of Delta Lake + Iceberg
Avatar for Databricks Japan databricksjapan
0
120
Snowflake Summit 2025 データエンジニアリング関連新機能紹介 / Snowflake Summit 2025 What's New about Data Engineering
Avatar for t-hiroto tiltmax3
0
170

Featured

See All Featured
Java REST API Framework Comparison - PWX 2021
Avatar for Matt Raible mraible
31
8.6k
The Cost Of JavaScript in 2023
Avatar for Addy Osmani addyosmani
50
8.4k
What’s in a name? Adding method to the madness
Avatar for Product Marketing Alliance productmarketing
PRO
22
3.5k
Designing for Performance
Avatar for Lara Hogan lara
609
69k
Sharpening the Axe: The Primacy of Toolmaking
Avatar for Bryan Cantrill bcantrill
43
2.4k
Navigating Team Friction
Avatar for Lara Hogan lara
187
15k
Performance Is Good for Brains [We Love Speed 2024]
Avatar for Tammy Everts tammyeverts
10
910
The Myth of the Modular Monolith - Day 2 Keynote - Rails World 2024
Avatar for Eileen M. Uchitelle eileencodes
26
2.8k
KATA
Avatar for Megan Lloyd mclloyd
29
14k
Code Review Best Practice
Avatar for Trisha Gee trishagee
68
18k
Speed Design
Avatar for Sergey Chernyshev sergeychernyshev
31
1k
Become a Pro
Avatar for Speaker Deck speakerdeck
PRO
28
5.4k

Transcript

  1. None

  2. Foundation - Pl\pgsql Loadable procedural language for the PostgreSQL database

    system.

  3. About me

  4. Why PostgreSQL https://medium.com/@fengruohang/postgres-is-eating-the-database-world-157c204dcfc4

  5. What is PL\pgSQL?

  6. Language —> Block is enclosed in Quotes https://cloud.tembo.io/

  7. PL/pgsql is a block-structured language —> Block is enclosed in

    Quotes —>Quotes Escaping

  8. Dollar Quoting $$ —> Block is enclosed in Quotes

  9. Functions in Pl\pgsql —> Block is enclosed in Quotes

  10. SQL as Language for Functions

  11. Procedural code - Volatility

  12. Procedural code - Extra Warning

  13. Plpgsql with your Favourite Code Editor.

  14. PLpgsql compilation —> Block is enclosed in Quotes

  15. Fun Demos —> Block is enclosed in Quotes

  16. My Database Courses