I know that PostgreSQL tables that use a SERIAL primary key end up with an an implicit index, sequence and constraint being created by PostgreSQL. The question is how to rename these implicit objects when the table is renamed. Below is my attempt at figuring this out with specific questions at the end. I know that PostgreSQL tables that use a SERIAL