A variety of approaches to creating synthetic data for PostgreSQL databases, from building data in Postgres itself, to mock data generators, to full-on data de-identification and synthesis.

Relational database design attempts to achieve this by modelling data into appropriate entities and creating relations (links) between the entities.