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.
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.
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.
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.