How to determine which version of PostgreSQL you are running
Run this SQL command to see which version of PostgreSQL you are running:
select version();
Reference: PostgreSQL Wiki
Command Palette
Search for a command to run...
Comments
Join the discussionNo comments yet. Be the first to comment.
More from this blog
Help! Where is my Sublime Context Menu option
After I upgraded to Windows 11, my Sublime Text right-click context menu disappeared. Putting this here for my future reference, and hope it helps the next person. Cheers! @echo off REM Add Sublime Text to Windows 11 Right-Click Context Menu REM Run ...
Nov 21, 20251 min read
How to search and replace text in VIM
This post is short and sweet for now. I plan on adding more commands as I get more familiar with VIM. Today I wanted to search and replace text in a JSON file using VIM. Turns out it is rather easy. :%s/"login"/"username"/g In my situation I needed ...
Dec 11, 20241 min read
GIT fatal: refusing to merge unrelated histories
This is a short and sweet post. I often will start a project by initializing my project with git locally: git init . I then went to GitHub and created the project there. I chose a license file since this was a public repository. That created the ini...
Nov 25, 20241 min read
How to install VirtualBox Guest Additions on Ubuntu Server Commandline
This morning, I struggled to get Guest Additions installed on my Ubuntu Server VBox, which I am going to use to prepare a codebase for migration to Linux. It has been a while since Digital Ocean droplets are inexpensive to fire up and use. Here are t...
Apr 2, 20241 min read
How to get the last 10 queries by table name in MySQL
Last 10 queries I had a situation where I wanted to check if some SQL changes I made were working properly. It involved a transaction with a bunch of queries. Yes I could verify the data but I wanted to visually see the queries that my scripts were g...
Apr 14, 20231 min read