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?
ALTER SEQUENCE dogs_id_seq RENAME TO ani.dogs_id_seq this won't work.