How To Install PostgreSQL 9.6 on Ubuntu 20.04

Install postgresql 9.6 Ubuntu 20.04

Introduction In this tutorial, we learn how to install PostgreSQL 9.6 on Ubuntu 20.04 (Focal Fossa). PostgreSQL, or usually called Postgres, is an open-source object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. PostgreSQL is ACID-compliant and transactional. It is developed by PostgreSQL Global Development Group (PGDG) that consists of many … Read more

How to Generate Random Data in PostgreSQL

Overview In this tutorial we learn how to generate random data in PostgreSQL. This method is sometimes needed to test the functionality of a PostgreSQL installation whether locally or remotely. Generate Random Data using md5 function in PostgreSQL To generate Generate data using generate_series function Generate data from random words in words.list file Create table … Read more