| From: | Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com> |
|---|---|
| To: | Simon Connah <simon(dot)n(dot)connah(at)protonmail(dot)com> |
| Cc: | "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Loading test data into a PostgreSQL database |
| Date: | 2021-05-15 10:49:13 |
| Message-ID: | CAFS1N4iRKov4UsPfzDT7aVeDRoCF6HBDURS0dJdVu1OzLUqWGQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
>
>
>
> 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.
https://www.postgresql.org/docs/13/manage-ag-templatedbs.html
Regards,
Jayadevan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Connah | 2021-05-16 19:01:04 | Re: Loading test data into a PostgreSQL database |
| Previous Message | Bill Ross | 2021-05-14 19:27:02 | Re: Loading test data into a PostgreSQL database |