Close
  • Blog
  • About
×
×
  • Blog
  • About
Menu & Search
MSSQL DBA Blog
PostgreSQL

PostgreSQL

May 5, 2022
MySQL
Postgres
RedShift
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.

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

Read More
WHERE 1=1
September 21, 2020
MySQL
Postgres
RedShift
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.

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

Read More
PostgreSQL
May 14, 2018
Postgres
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
Peter Whyte DBA

Peter Whyte

Blog Menu

  • Homepage
  • MSSQL DBA Blog
  • SSMS Tips
  • SQL Notes & Links
  • DBA Blog Archives
  • WSL Windows Tips
  • Projects

Categories

  • AWS (5)
  • Linux (34)
  • MySQL (5)
  • Postgres (7)
  • PowerShell (48)
  • RedShift (7)
  • SQL Server (78)
  • Windows (64)
  • WordPress (2)

Tags

Active Directory (AD) (4) AWS CLI (3) CDC (2) Certificates & Encryption (3) Change Data Capture (2) CSV Files (4) Database Admin (54) Database Backups (10) Data Types (2) Deleting Data (2) Error Messages (4) Featured (4) Git (11) Git Commands (4) Git Log (3) Installing SQL Server (10) Linked Servers (3) Linux Admin (2) Measuring Databases (9) MSSQL SPIDs (3) NetFirewallProfile (3) New-Item PowerShell (2) PowerShell Create Folder (2) PowerShell Delete Files (2) PowerShell ForEach (2) PowerShell Tips (20) PowerShell Version (2) Restoring Databases (7) SQL Server Agent (4) SQL Server ETL (2) SQL Server Management Studio (SSMS) (14) SQL Server Processes (6) SQL Server Scripts (3) SQL Tips (19) SSH (2) SSMS Tips (9) Temp DB (2) Windows Admin (21) Windows Firewall (4) WordPress Tutorials (2) WSL (22) WSL1 (4) WSL2 (4) WSL Ubuntu (6) WSL Version (4)