Lock in $30 Savings on PRO—Offer Ends Soon! ⏳

Foundation - Pl\pgsql

Deepak Mahto
June 17, 2024
Technology
0
80

Foundation - Pl\pgsql

Webinar on Foundation - Procedural Development with PostgreSQL.

Highlight importance on development near data, PL\pgSQL Internals.

Deepak Mahto

June 17, 2024
Tweet

More Decks by Deepak Mahto

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

Other Decks in Technology

See All in Technology
データ基盤の負債解消のためのリプレイス
livesense
PRO
0
130
12/2(月)のBedrockアプデ速報（re:Invent 2024 Daily re:Cap #1 with AWS Heroes）
minorun365
PRO
1
240
偶有的複雑性と戦うためのアーキテクチャとチームトポロジー
knih
7
6k
歴史あるRuby on Railsでデッドコードを見つけ、 消す方法@yabaibuki.dev #3
ayumu838
0
1.7k
総会員数1,500万人のレストランWeb予約サービスにおけるRustの活用
kymmt90
3
2.7k
AWS re:Invent 2024 予選落ちのBedrockアプデをまとめて解説！
minorun365
PRO
2
230
GeminiとUnityで実現するインタラクティブアート
hokkey621
0
330
複雑なCI/CDから脱却したアーキテクチャ：NTTグループの内製プラットフォーム事例を通して / An Architecture Achieving Simplified CI/CD: Insights from NTT Group's In-House Platform Case Study
nttcom
0
140
全社員に向けて生成AI活用を促進！～電通総研の生成AI活用ロードマップ～
iotcomjpadmin
0
290
AWS認定試験の長文問題を早く解くコツ
keke1234ke
0
140
PFN Company Deck
pfn
PRO
2
140
ご挨拶
iotcomjpadmin
0
290

Featured

See All Featured
The Art of Programming - Codeland 2020
erikaheidi
53
13k
For a Future-Friendly Web
brad_frost
175
9.4k
The Pragmatic Product Professional
lauravandoore
32
6.3k
Designing for Performance
lara
604
68k
The Power of CSS Pseudo Elements
geoffreycrofte
73
5.3k
Making the Leap to Tech Lead
cromwellryan
133
8.9k
Making Projects Easy
brettharned
115
5.9k
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
irinanazarova
4
400
Site-Speed That Sticks
csswizardry
0
88
A better future with KSS
kneath
238
17k
Building Better People: How to give real-time feedback that sticks.
wjessup
364
19k
Gamification - CAS2011
davidbonilla
80
5k

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