Advanced psql | Postgres.FM 120 |
[ 🇬🇧_🇺🇸 Check out the subtitles – we now edit them, ChatGPT+manually! You can also try YouTube's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]
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/curre...
Our episode on psql vs GUIs https://postgres.fm/episodes/psql-vs-...
postgres_dba https://github.com/NikolayS/postgres_dba
Our episode on massive deletes https://postgres.fm/episodes/massive-...
Postgres hacking session on \watch with limited number of loops • Postgres Hacking 101: \watch with lim...
pspg https://github.com/okbob/pspg
Our episode on Postgres gotchas https://postgres.fm/episodes/postgres...
current_setting() and set_config() docs https://www.postgresql.org/docs/curre...
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 in the comments, or by tweeting us on @postgresfm / postgresfm , @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is produced by:
Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/
Michael Christofides, founder of pgMustard https://pgmustard.com/
~~~
This is the video version. Check out https://postgres.fm to subscribe to the audio-only version, to see the transcript, guest profiles, and more.