"Crombleholme, Roy" <Roy.Crombleholme@its.lancscc.gov.uk> writes:
> Hello, I've changed the owner of a table in a database from the super-user
> to a normal user using the command ALTER TABLE table OWNER TO user;
> This changed the owner of the table but not the sequence associated with it.
> What is the command to do this.
A sequence is a table for many purposes, including this one. So, it's
ALTER TABLE seqname OWNER TO whoever.
regards, tom lane
