Simplest syntax (or a UI?) to rename columns and sequences and constraints (etc)?

Is there a SQL/ALTER (pg proprietary or otherwise) syntax that uniformly
changes the names off all object tied to a column when that column name
is changed? Or can anyone recommend a UI that does this?

For example in a table 'foo' I have a 'rowid' (pk and auto increment)
and I choose to rename it. The default naming convention given to the
supporting sequence is 'foo_rowid_seq', so (ignoring safely/ambiguity
issues) is it possible rename 'rowid' and have the changes cascade to
sequences, constraints, etc?

Ken