Close
  • Blog
  • About
×
×
  • Blog
  • About
Menu & Search
Peter Whyte DBA Blog
PostgreSQL

PostgreSQL

May 5, 2022
MySQL
PostgreSQL
RedShift
Why Use WHERE 1=2 in SQL

Some time ago I wrote short 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.

Read More
May 2, 2022
Linux
PostgreSQL
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.

Read More
List All Schemas Tables and Columns in RedShift
September 27, 2020
PostgreSQL
RedShift
List all Schemas/Tables/Columns in Redshift & Postgres

This is a post containing a query that’ll bring back all schemas, tables, and columns in Redshift or Postgres databases. I’m combining the Redshift and Postgres database blog categories here…

Read More
SQL Scripts Feature
September 21, 2020
MySQL
PostgreSQL
RedShift
Why use WHERE 1=1 in SQL Queries

A common SQL question is, why does anyone use WHERE 1=1 in their queries? And what does it do? The condition means WHERE TRUE, so it’s just bringing back the same query result as it would without.

Read More
Create Linked Server with Postgres
March 10, 2019
PostgreSQL
SQL Server
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!

Read More
fe_sendauth: no password supplied
May 15, 2018
PostgreSQL
Reset Default PostgreSQL User Password

If you forget what you entered as the postgres user password during installation, then this is a guide for you! It’s exactly what I did which is the reason for a post.

Read More
PostgreSQL
May 14, 2018
PostgreSQL
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.

Read More
DBA Blog

author: Peter Whyte

GithubTwitterRss

Blog Menu

  • Homepage
  • Projects
  • Notes
  • Archives

Categories

  • AWS (3)
  • Linux (30)
  • MySQL (5)
  • PostgreSQL (7)
  • PowerShell (36)
  • RedShift (6)
  • Scripts (1)
  • SQL Server (59)
  • Windows (50)
  • WordPress (5)

Tags

Certificates & Encryption (3) CSV Files (3) Database Admin (38) Database Backups (5) Data Types (2) Deleting Data (2) Error Messages (4) Exporting Data (1) Featured (6) Git (7) Importing Data (1) Installing SQL Server (9) Linked Servers (3) Linux Admin (2) Logging & Monitoring (1) Measuring Databases (7) Restoring Databases (5) SQL Agent (1) SQL Server Agent (3) SQL Server ETL (2) SQL Server Management Studio (9) SQL Server Processes (4) SQL Server Scripts (2) SQL Tips (2) Windows Admin (12) WordPress Tutorials (2) WSL (19)