Re: resetting primary key after copy

From: "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com>
To: "Don Guernsey" <dononyx(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: resetting primary key after copy
Date: 2007-02-12 17:46:10
Message-ID: b35603930702120946v76c52f18m7b6582d035ec74da@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 2/13/07, Don Guernsey <dononyx(at)yahoo(dot)com> wrote:
> does anyone know how to do this? I need to reset the
> primary key after I copy a bunch of data to postgres.
> The other option would be to start my tables primary
> key at a high number, like 3000000. Any Ideas?
Just a question: what do you mean by "reset the primary
key"?

Cheers,
Andrej

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Derrick Betts 2007-02-12 18:00:32 Re: resetting primary key after copy
Previous Message A. Kretschmer 2007-02-12 17:45:57 Re: resetting primary key after copy