Database

PGX Error: Cannot scan unknown type

You probably end up here because you saw this error returned from jackc/pgx cannot scan unknown type (OID 16458) in text format into *[]recipe.CategoryType This error is connected with custom database types, so if this is what you did, this article is for you. ...

Unleashing the Power of PostgreSQL: Processing JSON Data Like a Pro!

Learn how to load, process, and insert data into a PostgreSQL database using JSON data. In this article, I’ll walk you through preparing and processing JSON data with PostgreSQL. ...