PostgreSQL in Azure Data Studio
Learn how to install PostgreSQL and using Azure Data Studio to work with it.
2022-01-31
7,388 reads
postgresql
SQL VIEW Comparison in SQL Server, Oracle and PostgreSQL
In this article we look at the similarities and differences for views in SQL Server, Oracle and PostgreSQL. We also look at indexed views, materialized views and updatable views.
2021-08-16
SQL Window Functions in SQL Server, Oracle and PostgreSQL
In this article we look at using Window Functions in SQL Server, Oracle and PostgreSQL to see the differences and similarities of the syntax.
2021-04-19
Upgrade PostgreSQL 9.X to 12.X in Windows
Learn how you can upgrade a PostgreSQL server and ensure your databases follow to the new version.
2021-02-09
42,148 reads
SQL Update Statement with Join in SQL Server vs Oracle vs PostgreSQL
In this article we look at the different SQL syntax you need to use when updating data when joining tables for SQL Server, Oracle and PostgreSQL.
2021-01-29
Getting started with PostgreSQL on MacOS
This article covers how to install PostgreSQL on the macOS.
2020-11-19
3,718 reads
Installing PostgreSQL 11 on Windows with Step-by-step Instructions
PostgreSQL is a free database management system (DBMS). PostgreSQL 11 is the new version of this DBMS. We will take a look at how to install PostgreSQL 11 on Windows. This article covers where to download PostgreSQL 11, how the installation process looks like, and how to connect to the PostgreSQL server. Step-by-Step Installation on Windows […]
2020-09-03
21,196 reads
Postgresql JDBC Tutorial on Linux
PosgtreSQL is a free and general purpose open source object-relational database system that uses and extends the SQL language. Though originally designed to run on UNIX platforms, Postgres is able to run on various platforms, such as macOS, Solaris, Windows, Unix, and Linux. PostgreSQL databases provide enterprise-class database solutions and are used by a wide […]
2020-05-11
9,802 reads
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
What's the Date?
Comments posted to this topic are about the item What's the Date?
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers