alter sequence

From: Peter Kroon <plakroon(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: alter sequence
Date: 2012-11-24 11:32:56
Message-ID: CAOh+DOk=ESPavfj8fWzx+1E+MSWJXuDnexiAEiAbY0qiprbAUQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Angelico 2012-11-24 11:37:18 Partial authentication (was Re: sefety of passwords for web-service applications)
Previous Message Vlad K. 2012-11-24 10:05:38 Re: sefety of passwords for web-service applications