Re: reduce number of multiple values to be inserted - Mailing list pgsql-general

From Rob Sargent
Subject Re: reduce number of multiple values to be inserted
Date
Msg-id 61b9cfc8-6cc7-ba64-1ca0-628ff65e1710@gmail.com
Whole thread Raw
In response to Re: reduce number of multiple values to be inserted  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: reduce number of multiple values to be inserted
List 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)? ;)


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: reduce number of multiple values to be inserted
Next
From: tango ward
Date:
Subject: Re: reduce number of multiple values to be inserted