ALTER SEQUENCE to use schema? Consider tables cats and dogs in ani animals schema.
During sequences creation, sequence for cats.id used schema, whereas sequence for dogs.id didn't use schema:
create sequence ani.cats_id_seq
create sequence dogs_id_seq

How can I modify the dogs_id_seq so it also uses schema?
For example: ALTER SEQUENCE dogs_id_seq RENAME TO ani.dogs_id_seq this won't work.
See the documentation:
ALTER SEQUENCE dogs_id_seq SET SCHEMA ani;