Advanced psql | Postgres.FM 120 | #PostgreSQL #Postgres podcast

[ 🇬🇧_🇺🇸 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:

~~~

~~~

Postgres FM is produced by:

~~~

[kirkwolak]

Good Stuff. I looked into enabling TIMING all of the time. It's 2 lines of code on the client side. Where \timing ON is slow because it outputs the time. Just tracking it and setting a variable EXEC_TIME or SQL_EXEC_TIME would be cool. Because if you did something, and it took a long time, but you were not paying attention. You could \ECHO :SQL_EXEC_TIME and see it. (Also, this means you could actually code a script to be aware of how long things are taking without extra tracking on your own)...