How to Create the Initial Postgresql Database?

You've just installed PostgreSQL and attempt to run psql and get the following error: FATAL: database 'user' does not exist. Here's how to fix that

Read the rest

Partial index in postgres

What is a partial index? A partial index is an index built over a subset of a table; the subset is defined by a conditional...

Read the rest