Re: reduce number of multiple values to be inserted

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: reduce number of multiple values to be inserted
Дата
Msg-id 61b9cfc8-6cc7-ba64-1ca0-628ff65e1710@gmail.com
обсуждение исходный текст
Ответ на Re: reduce number of multiple values to be inserted  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: reduce number of multiple values to be inserted  (tango ward <tangoward15@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: reduce number of multiple values to be inserted
Следующее
От: tango ward
Дата:
Сообщение: Re: reduce number of multiple values to be inserted