Why Use WHERE 1=2 in SQL
Some time ago I wrote a blog post on why use WHERE 1=1 in SQL. This time it’s why use WHERE 1=2, but really this can be WHERE 1=9 or anything that isn’t a 1, we just want the false statement.
How to Install Postgres on Ubuntu 20.04
This post is a short note on how to install Postgres on Ubuntu 20.04.I’m doing this in WSL, however this shouldn’t make any difference if you’re on the same Ubuntu version.
List all Schemas, Tables & Columns in Redshift or Postgres
This post contains a SQL script that will return all schemas, tables and columns in Redshift or Postgres.I’m combining the Redshift and Postgres database blog categories here.
Why use WHERE 1=1 in SQL Queries
A common SQL question is, why would anyone use WHERE 1=1 in their queries? And what does it do?The WHERE 1=1 condition means WHERE TRUE.
Creating a Linked Server with a Postgres Database
In my previous post, I created a Link Server to another SQL Server instance This time, it’s a link to a Postgres database!
Reset Default PostgreSQL User Password
A common scenario working with Postgres is when you have forgotten your default Postgres user password. This is the password you will have entered during your Postgres installation.
How To Install PostgreSQL on Windows
PostgreSQL is a free open-source RDMS that is widely used and forked. Other than PostgreSQL itself, Redshift is the only other forked database I’ve ever touched.
