PostgreSQL – Rename Sequence

You can use the below command to rename an existing sequence where seq_name is the current name of the sequence and new_seq_name is the name you would like to rename it to.

ALTER SEQUENCE seq_name RENAME TO new_seq_name;

See also  PostgreSQL - Get table size