Postgres Pro
Downloads
Home   >   mailing lists

Re: updating a sequence - Mailing list pgsql-sql

From Richard Broersma
Subject Re: updating a sequence
Date
Msg-id CABvLTWGNa470FXAR=zXu_PeFJ9GtQ-MPAcDfq=Bq7vPVuF2drA@mail.gmail.com
Whole thread Raw
In response to updating a sequence  (John Fabiani <johnf@jfcomputer.com>)
Responses Re: updating a sequence  (John Fabiani <johnf@jfcomputer.com>)
List pgsql-sql
Tree view 
On Tue, Nov 15, 2011 at 8:06 AM, John Fabiani <johnf@jfcomputer.com> wrote:

> alter sequence somename restart with (select max(pk) from sometable).
>
> I need this for automating an ETL (using pentaho).

http://www.postgresql.org/docs/9.1/interactive/functions-sequence.html#FUNCTIONS-SEQUENCE-TABLE


-- 
Regards,
Richard Broersma Jr.

pgsql-sql by date:

Previous
From: John Fabiani
Date:
Subject: updating a sequence
Next
From: Craig Ringer
Date:
Subject: Re: pg_dump : problem with grant on table columns