Tag: 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…
-
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…
Three guides collect the posts by the job you are doing rather than by date.
PowerShellFiles, CSVs, the firewall, scheduled tasks WSLInstalling it, distros, files across both worlds Windows AdministrationServers, domains, DNS, the tools worth havingThis site started as a SQL Server blog in 2017 and the archive is still here. The new SQL Server writing, and all the scripts, moved to a site of their own.
sqldba.blogScripts, error library, wait types, SSMS- Linux & WSL (28)
- Microsoft SQL Server (50)
- Other (13)
- PowerShell (53)
- Windows Server Admin (38)