Many times we need to populate and eventually share a database with dummy data, either to test our pipelines, test queries, make a demo of the operation of a new service, or perhaps as a tool to apply testing to the future members of the company.

_Github repo: _https://github.com/jdaarevalo/docker_postgres_with_data

Introduction

Among the various options that we have to solve this requirement is to use or share files such as CSV, parquet, s3, among others, but those have limitations in each of the challenges that we want to face.

This is a problem that can be solved easily by making use of the features that Docker offers to us.

Our goal here will be to create the following tables with their respective foreign keys and fill the tables, while they can be easily shared with other users.

#postgres #docker-compose #fill-tables #docker #postgresql