Interacting with PostgreSQL and other database engines

Popular database engines, such as PostgreSQL or MariaDB, often do not have dedicated, well-maintained PowerShell modules. In those cases, we usually need to revert to .NET on PowerShell Core.

Luckily, we can at least use standardized ways of accessing those engines. This recipe examines PostgreSQL, but the learning can be applied to any database engine that offers up a .NET library to handle connections.

Getting ready

Install and start PowerShell Core. To interact with a PostgreSQL database, you can use your favorite hosting or cloud provider. Azure has a PostgreSQL offering to create a full-fledged PostgreSQL server. Most hosting providers will offer you some managed...