Postgres Search All Tables For Value

Introduction How to use Postgres to search all tables for a value. We’ll start by setting up a database connection to Postgres from Python. Next we will cycle through all tables. Finally, for each table, we will search each column in that table, looking for our target string. Here is the plan: Set up a … Continued

Postgres Search a Column

Introduction We will teach you how to use various applicable functions in Postgres to search a column for a specific character or string (word). The functions we will explore here include: Substring, Position, StrPos, and Reverse. Prerequisites Ability to- and knowledge of- how to write Postgres SQL. Knowledge of the use of the most basic … Continued

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.