PostgreSQL Rename Column
The RazorSQL alter table tool includes a Rename Column option for renaming an PostgreSQL database table column. The rename column option allows the user to type in a new name for the column being renamed. The tool then generates and can execute the SQL to rename the column on the table.
Listed below is an example of the SQL generated by the PostgreSQL Rename Column function:
ALTER TABLE sample.public.employee
RENAME COLUMN ssn TO ssn_copy
Below is a screen shot of the rename column function of the PostgreSQL alter table tool.
