Learning Postgres

Mostly based on PostgreSQLTutorial.com

TODO:

• Gin, gist with search text
• Search text, ts_rank
• Search text && || !! : https://www.postgresql.org/docs/current/functions-textsearch.html
• Window Functions
• citext for email validation
• generate_series
• EXIT with block labels
• Complete PL/pgSQL
• Transactions > Save Point
• CREATE EVENT TRIGGER vs CREATE TRIGGER for TSVECTOR
• SELECT * FROM film; \_text of special_features

DBeaver shortcuts that are not aligned with VS Code

Action	Command
Indent	Highlight the lines, then press Tab
Outdent	Highlight the lines, then press Shift + Tab
Multi-Line Comment	Ctrl + Shift + /