Loading test data into a PostgreSQL database

Поиск
Список
Период
Сортировка
От Simon Connah
Тема Loading test data into a PostgreSQL database
Дата
Msg-id O2VViuum_GZUdON4Mu0l9-5yKa00VIgQSkofE4DOwpR3I59u0GRKiP4YUULpEltxXAAIt82ii-SqXsJUKEiNNR3HNRDHkHfyCyiMrOeeECg=@protonmail.com
обсуждение исходный текст
Ответы Re: Loading test data into a PostgreSQL database  (Bill Ross <ross@cgl.ucsf.edu>)
Re: Loading test data into a PostgreSQL database  (Jayadevan M <maymala.jayadevan@gmail.com>)
Список pgsql-novice
Hi,

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
(Idon't want to update the version number for the initial release). So, what is the normal way of creating some test
datato put in the database because obviously, when you do DROP EXTENSION, it deletes everything? 

Can I make a CSV file and import it into the database? Or do I have to write some custom SQL to handle that aspect? Or
isthere an easier method I should be using? Or could I add some test data to the extension itself? 

Simon.


Вложения

В списке pgsql-novice по дате отправления:

Предыдущее
От: Pól Ua Laoínecháin
Дата:
Сообщение: Re: Transaction ISOLATION LEVEL - have I missed something?
Следующее
От: Bill Ross
Дата:
Сообщение: Re: Loading test data into a PostgreSQL database