For PostgreSQL powerusers, automating repeated steps is becoming more and more necessary, and gexec can help. This blog will show you how to use the || operator and the \gexec command to avoid unnecessary repetition in your workflow. The CLI client that ships with PostgreSQL is called psql. Like many CLI clients, it is often […]

In this post, we want to give you a brief introduction to TLS (Transport Layer Security), which is a technology widely used in combination with PostgreSQL to encrypt client / server connections. What is TLS? TLS is short for “Transport Layer Security“, which is a means of making sure that whatever data you are sending […]