Re: reduce number of multiple values to be inserted

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: reduce number of multiple values to be inserted
Date: 2018-05-30 00:40:23
Message-ID: 61b9cfc8-6cc7-ba64-1ca0-628ff65e1710@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 05/29/2018 06:36 PM, Adrian Klaver wrote:
> On 05/29/2018 05:10 PM, tango ward wrote:
>>
>> Hi,
> Not sure where you are pulling the data from and how it is ordered,
> but an outline:
>
> data_input (Assuming sorted by village and then age)
>
> for village in data_input:
>     for age in village:
>          curr_pgsql.execute('''
>          INSERT INTO student (created, modified, name,
>                                       address, age, level)
>                  VALUES(current_timezone, current_timezone,
>                         %s, %s, %s, 2)''', (name, village, age))
>
>>
>>
>> Thanks,
>> J
>>
>
>
You might need random(name)? ;)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message tango ward 2018-05-30 00:49:27 Re: reduce number of multiple values to be inserted
Previous Message Adrian Klaver 2018-05-30 00:36:47 Re: reduce number of multiple values to be inserted