Proceeding from Part 1 and Part 2 of this series, today’s post will involve reading stored data in a PostgreSQL table using the SELECT statement along with filtering criteria in the WHERE clause for specific record searches. Modifying table data with the UPDATE command will also be visited to round out this discussion.
Latest Blog Posts
This post will demonstrate basic concepts for creating a simple database and table in PostgreSQL. These examples will brush the surface of the CREATE DATABASE and CREATE TABLE commands, providing a solid base, to begin with, and build on moving forward.
Searching numerous columns of data for particular records is time-consuming and less than productive. In this post, I will demonstrate pattern matching examples using the powerful
LIKE operator, found in both traditional SQL and PostgreSQL. Along with briefly visiting the PostgreSQL keyword
ILIKE as well.
In today’s post, I will demonstrate examples of PostgreSQL’s IN operator in stand-alone scenarios, along with additional uses combining IN with the NOT operator for other solutions or ideas of value matching checks against a list of values.