Close
  • Tech Blog
  • About
×
×
  • Tech Blog
  • About
Menu & Search
Peter Whyte
Category

PostgreSQL


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

Blog Menu

  • Homepage
  • All Posts
  • Index
  • Traffic
  • Scripts
  • Notes

Categories

  • Linux (11)
  • MySQL (4)
  • PostgreSQL (5)
  • PowerShell (18)
  • RedShift (4)
  • Scripts (1)
  • SQL Server (53)
  • Windows (32)
  • WordPress (5)

Tags

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

Recent Posts

Find String in Tables in SQL Server
November 30, 2020
Show Only the Domain of an Email Address in SQL Server
November 27, 2020
USE Command in SQL Server
November 25, 2020
Change Default Database in SQL Server
November 23, 2020
Install oh-my-posh On Windows
November 13, 2020