Re: Copy from and serial columns

Поиск
Список
Период
Сортировка
От Sean Davis
Тема Re: Copy from and serial columns
Дата
Msg-id 46DE18EF.3000702@mail.nih.gov
обсуждение исходный текст
Ответ на Copy from and serial columns  (Sean Davis <sdavis2@mail.nih.gov>)
Список pgsql-novice
Sean Davis wrote:
> I have a client (psycopg2) that only allows copies of the entire table
> (not specific rows).  I would like to use a SERIAL column on tables,
> but I cannot seem to figure out how to apply the default.  Trying to
> insert a NULL does not do it.  Is there another way, or should I do
> what is probably better and ask the client author to provide
> functionality for allowing subsets of columns to be passed to the copy
> command?

Sorry.  psycopg2 has a "columns" argument that I was not aware of.  This
will alleviate the problem.

Sean

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

Предыдущее
От: Sean Davis
Дата:
Сообщение: Copy from and serial columns
Следующее
От: Maximilian Tyrtania
Дата:
Сообщение: Using column references in default expression