Home > Documentation > PostgreSQL to MS SQL > FAQ

How to rename column in the resulting PostgreSQL table?

There are two options for this task. First solution is to use Edit Table feature of SQL Server to PostgreSQL converter. This feature can be accessed by double click on the corresponding table name in "Selected tables" list.

You can modify column name by migrating the corresponding table as result of SELECT-query with alias for particular column:

    SELECT FName as FirstName, ... FROM Table1

Then store query with name of the original table. To access this feature click "Add Query" button on "Step 4 of 5" page of the conversion wizard.

See Using Queries article for the further information.

Have more questions? Contact us