Advanced psql
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:
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!
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
