Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group