I'm currently working on a project using PostgreSQL 13 and using an extension with CREATE EXTENSION to create the database. However, if I want to make certain changes to the database, I have to drop the extension and then re-create it (I don't want to update the version number for the initial release). So, what is the normal way of creating some test data to put in the database because obviously, when you do DROP EXTENSION, it deletes everything?
Will using a template database work? Have your extension and other objects there. When you create your actual database, use the other one as the template.