PostgreSQL Knowledge Base

Follow along with one of our tutorials.

Looking for something specific? Search below.

SQL GROUP BY vs ORDER BY - The Difference Explained
SQL DISTINCT vs UNIQUE - What's the Difference?
SQL EXCEPT vs NOT IN - What's the Difference?
SQL HAVING vs WHERE - What's the Difference?
Function vs Stored Procedure in SQL
Delete vs Truncate in Postgresql
Decimal vs Double in SQL
MySQL vs PostgreSQL 2019
Primary Key vs Foreign Key
How to Use Regex in PostgreSQL - LIKE and ~ Tilde
What are the Differences Between MySQL and PostgreSQL?
About PostgreSQL SQL
Casting in PostgreSQL
JOIN three tables in PostgreSQL
Self-JOIN in PostgreSQL
The PostgreSQL Challenge - Question 1

Pilot the ObjectRocket Platform Free!

Try Fully-Managed CockroachDB, Elasticsearch, MongoDB, PostgreSQL (Beta) or Redis.

Get Started

Keep in the know!

Subscribe to our emails and we’ll let you know what’s going on at ObjectRocket. We hate spam and make it easy to unsubscribe.