Massive data upload process in postgresql

Navigation
0

I have been researching this and sincerely what I find of information does not convince me (little information, by the way) what I try to do is enter 5000 data in 4 different postgresql tables and I have found that the COPY function works for a csv file, but I do not understand something: Do I have to write the 5000 data in the excel? because what I'm looking for is that I generate them automatically, I know that in MySql there is a certain way of doing it, but in postgresql how is that process? or does not something similar exist? I have researched but I can not understand everything, I also tried with the postgresql manual but I did not find this information.

I've also heard that from PHP or Java this can be done, what would that process be?

    
asked by Gonzo30 16.03.2018 в 22:29
source

1 answer

1

If you are looking to generate 5000 random rows to import into your tables, I recommend link .

You only have to define the fields of the table, the number of rows and generate them in the format you want (CSV, JSON, SQL, etc.)

    
answered by 16.03.2018 / 22:55
source
export result of a nodedels middelware to a static js file Problem with arrays in visual studio (program problems)