Weekly screencasts on all things PostgreSQL
In this episode we will look at a handy shortcut to use when ordering rows in a select statement.
In this episode we will look at the ILIKE operator and see why it may not be well suited for doing full case-insensitive string comparisons.
In this episode, we're going to be looking at how we can use the citext module when working with case insensitive data.
In this episode, we're going to look at Postgres database views, what they are and why you might use them.
In this episode, I'm going to add a not null constraint to an existing Postgres column.
If you've ever wondered what's going on behind the scenes when you declare a column with the serial data type, then this episode's for you.
In this episode, we'll be looking at a unique index we can use when working with case-insensitive data.
In this episode, we're going to be looking at considerations we need to make when working with case-insensitive data.
Our topic this episode is the new 'skip locked' feature in PostgreSQL 9.5.
Hello! My name is Vidal Ekechukwu, and in this episode of PG Casts we’ll be using Lateral Joins to more efficiently aggregate columns. Ready? Let’s go.
In this episode, I'm going to demonstrate how to use the HStore datatype in Postgres.
In this episode, we will see how we can quickly generate a bunch of fake emails with nothing more than a fancy Postgres statement.
In this episode, I'm going to demonstrate how to use comments in Postgres.
In this episode I am going to show you how we can come up with a better display character for null values.
Generating JSON in PostgreSQL can be several times faster than copying the relational data to the application and then generating the JSON.