Difference between PostgreSQL Unicode v ANSI drivers

Should I use ANSI or Unicode PostgreSQL driver options? Read more →

How to change PostgreSQL default schema

Changing the Postgresql user default schema on a permanent basis Read more →

How to list PostgreSQL table constraints

How to check for Postgresql primary key, unique, foreign key, and exclusion constraints on tables. Read more →

How to fix python import requests not found

How to fix python import requests not found. This is a temporary fix Read more →

How to kill a PostgreSQL user session connection

Trying to DROP a PostgreSQL database but getting other user sessions blocking the command action Read more →

How to copy a PostgreSQL table to another database using pgAdmin

I just want to move a few tables and data between some PostgreSQL databases Read more →

My favourite sci-fi novels

This is not a definitive list - but is a quick scan of my bookshelf reveals some brilliant sci-fi Read more →

Is mongodb+srv necessary for a MongoDB connection

MongoDB SRV on connection strings allows better management on connection string management Read more →

MSSQL to PostgreSQL Migration - upper versus lower case

How to change the Postgresql upper case table and column names to lower case Read more →

A simple guide to migrate MS Access to PostgreSQL

A quick guide to migrating MS Access tables and data to Postgresql Read more →