Postgres Pro
Downloads
Home   >   mailing lists

alter sequence - Mailing list pgsql-general

From Peter Kroon
Subject alter sequence
Date
Msg-id CAOh+DOk=ESPavfj8fWzx+1E+MSWJXuDnexiAEiAbY0qiprbAUQ@mail.gmail.com
Whole thread Raw
Responses Re: alter sequence  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view
ALTER SEQUENCE (select pg_get_serial_sequence('table', 'id')) RESTART WITH 1;

The query fails:
ALTER SEQUENCE (select pg_get_serial_sequence('table...
it's because of the (

I guess I'm using the wrong syntax.
It is possible this way? Would be great!

Best,
Peter 

pgsql-general by date:

Previous
From: "Vlad K."
Date:
Subject: Re: sefety of passwords for web-service applications
Next
From: Chris Angelico
Date:
Subject: Partial authentication (was Re: sefety of passwords for web-service applications)