Re: Copy from and serial columns - Mailing list pgsql-novice

From Sean Davis
Subject Re: Copy from and serial columns
Date
Msg-id 46DE18EF.3000702@mail.nih.gov
Whole thread Raw
In response to Copy from and serial columns  (Sean Davis <sdavis2@mail.nih.gov>)
List 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 by date:

Previous
From: Sean Davis
Date:
Subject: Copy from and serial columns
Next
From: Maximilian Tyrtania
Date:
Subject: Using column references in default expression