Advanced psql — Postgres FM

Nikolay and Michael discuss some cool things you can do with psql, the official CLI that ships with Postgres.

Here are some links to things they mentioned:

psql docs https://www.postgresql.org/docs/current/app-psql.html
Our episode on psql vs GUIs https://postgres.fm/episodes/psql-vs-guis
postgres_dba https://github.com/NikolayS/postgres_dba
Our episode on massive deletes https://postgres.fm/episodes/massive-deletes
Postgres hacking session on \watch with limited number of loops https://www.youtube.com/watch?v=vTV8XhWf3mo
pspg https://github.com/okbob/pspg
Our episode on Postgres gotchas https://postgres.fm/episodes/postgres-gotchas
current_setting() and set_config() docs https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-SET
psql tips (site by Lætitia Avrot) https://psql-tips.org

~~~

What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!

~~~

Postgres FM is produced by:

Michael Christofides, founder of pgMustard
Nikolay Samokhvalov, founder of Postgres.ai

With special thanks to:

Jessie Draws for the elephant artwork