Tag: psql
usql: universal psql?
usql? But why? usql is a universal command-line interface for many database. But why are we still using CLI (command line utilities) in the 21st century? And what is wrong with psql? Despite the widespread availability and ease of use of GUI-based tools, many people still prefer to use command line utilities for a number […]
gexec in psql: PostgreSQL poweruser practice
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 […]
PostgreSQL GitHub Actions – Continuous Integration
Intro GitHub Actions (GHA) are altogether a piece of excellent machinery for continuous integration or other automated tasks on your repo. I started to use them from the release day on as a replacement for CircleCI. Not that I think CircleCI is a bad product; I love to have everything in one place if possible. […]
PSQL_EDITOR: Fighting with Sublime Text under Windows
This is a How-To blog about the PSQL_EDITOR variable. While trying to figure out all possible pitfalls, I’ve somehow managed to write a full blog post. You may skip to the summary though. All tests were done on Windows 10 with PostgreSQL 12 installed. As you know, PostgreSQL ships with an interactive console tool named […]
Producing LaTeX output
I think I first touched PostgreSQL in 1998 or 1999. It has been a long time, but PostgreSQL keeps inspiring me. I still keep finding cool features which have most likely been around for 15 years or more. Recently, I noticed by coincidence that psql can produce perfect LaTeX code. How cool is that? It’s […]