Re: alter sequence - Mailing list pgsql-general

Hello

you can't to do it directly. Expression cannot be used instead object name

you can use a plpgsql DO in this moment

DO $$
BEGIN
  EXECUTE format('ALTER SEQUENCE %I RESTART WITH 1',
pg_get_serial_sequence('table', 'id'));
END;
$$ LANGUAGE plpgsql;

Regards

Pavel Stehule

2012/11/24 Peter Kroon <plakroon@gmail.com>:
> ALTER SEQUENCE (select pg_get_serial_sequence('table', 'id')) RESTART WITH
> 1;