On Thu, Dec 9, 2010 at 10:56 PM, Shoaib Mir <shoaibmir(at)gmail(dot)com> wrote:
> I guess I misread it... use the following:
>
> - Import all the data into say an integer column.
> - Now create a sequence and give it a start value of where your import
> ended.
> - Make the default value for the column using the new sequence.
>
create the table with a SERIAL column, which will make the sequence
and set the auto increment default as you wanted.
import the data
update the sequence with setval() to the next highest value you want
it to return, usually max()+1 of the populated column.