Postgres

Postgres Blog Post Archives: Tips and SQL Scripts to help with Postgres, written by a Microsoft SQL Server DBA (cross-over posts).

  • Why Use WHERE 1=2 in SQL

    In a previous blog post, I explained why WHERE 1=1 is often used in SQL queries. This time, let's discuss WHERE 1=2 — or any condition that results in a FALSE…

  • How to Install Postgres on Ubuntu 20.04

    This post is a short note on how to install Postgres on Ubuntu 20.04.

  • List all Tables & Columns in Redshift or Postgres

    If you need to list all tables and columns in Redshift or Postgres, this guide provides a SQL script to retrieve schema details across all databases.

  • Creating a Linked Server for a PostgreSQL Database

    This is a post on how to create a Linked Server to a PostgreSQL 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. This is a guide on how to reset the default Postgres user password. This should hopefully help you resolve this issue on your test Postgres environment. Resetting […]

  • How To Install PostgreSQL on Windows

    🛠️Part of the Windows Administration Complete Guide, every Windows administration post on this site, grouped by the job you are doing. 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. This blog post is a very simple wizard […]