PostgreSQL
PostgreSQL Data Types: ENUM
Continuing our series of PostgreSQL Data Types today we’re going to introduce the PostgreSQL ENUM type. This data type has been added to PostgreSQL in order to make …
category
PostgreSQL
135 posts
PostgreSQL
PostgreSQL Data Types: JSON
Continuing our series of PostgreSQL Data Types today we’re going to introduce the PostgreSQL JSON type. PostgreSQL has built-in support for JSON with a great range …
PostgreSQL
PostgreSQL Data Types: XML
Continuing our series of PostgreSQL Data Types today we’re going to introduce the PostgreSQL XML type. The SQL standard includes a SQL/XML which introduces the …
PostgreSQL
PostgreSQL Data Types: Arrays
Continuing our series of PostgreSQL Data Types today we’re going to introduce the PostgreSQL array data types. Arrays can be used to denormalize data and avoid …
PostgreSQL
PostgreSQL Data Types: Ranges
Continuing our series of PostgreSQL Data Types today we’re going to introduce the PostgreSQL ranges data type. Range types are a unique feature of PostgreSQL, …
PostgreSQL
PostgreSQL Data Types: Network Addresses
Continuing our series of PostgreSQL Data Types today we’re going to introduce network address types. PostgreSQL includes support for both cidr, inet, and macaddr …
PostgreSQL
PostgreSQL Data Types: Date and Time Processing
Continuing our series of PostgreSQL Data Types today we’re going to introduce date and time based processing functions. Once the application’s data, or rather …
PostgreSQL
PostgreSQL Data Types: Text Processing
Continuing our series of PostgreSQL Data Types today we’re going to introduce some of the PostgreSQL text processing functions. There’s a very rich set of …
PostgreSQL
PostgreSQL Data Types: Text Encoding
Continuing our series of PostgreSQL Data Types today we’re going to introduce the PostgreSQL text data type. The first notion to understand when processing text in …
PostgreSQL
PostgreSQL Data Types: an intro
Today, we’re going to begin a dive into the PostgreSQL Data Types. As my colleague Will Leinweber said recently in his talk Constraints: a Developer’s Secret …
PostgreSQL
Object Relational Database Management System
PostgreSQL is the world’s most advanced open source database, and per the PostgreSQL Wikipedia page it is an object-relational database management system (ORDBMS) …
PostgreSQL
Database Normalization and Primary Keys
In our previous article we saw three classic Database Modelization Anti-Patterns. The article also contains a reference to a Primary Key section of my book The Art of …