This is essentially the same question as How do I rename a column in a database table using SQL?.
So, I want to rename a column in a table. This column is part of a set of tables that lives inside a PostgreSQL schema, which is itself in a PostgreSQL database.
However, I also have constraints like foreign keys involving this column. It is not clear to me whether this command will also take care of constraints. If not, how should I handle this?
Alternatively, I also have this database available as a dump file. Would it make sense to edit the dump file, and if so, how?