Re: reduce number of multiple values to be inserted

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: reduce number of multiple values to be inserted
Дата
Msg-id 678DB604-B589-4875-8F49-16A75F735BF3@gmail.com
обсуждение исходный текст
Ответ на Re: reduce number of multiple values to be inserted  (tango ward <tangoward15@gmail.com>)
Список pgsql-general


On May 29, 2018, at 6:32 PM, tango ward <tangoward15@gmail.com> wrote:

On Wed, May 30, 2018 at 8:29 AM, Rob Sargent <robjsargent@gmail.com> wrote:

Is “current_timezone, current_timezone” just a typo?  I think you need to make the 117 data lines and load using \copy



Sorry, yeah, it's current_timestamp. 


David and I are suggesting the same thing.  You have 117 unique student definitions so you need to explicitly define each of them. That can be in your python code or in a file your python code reads in and generates inserts or simply a psql script which reads the file using \copy tablename from file.  

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

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