How to rename column in the resulting PostgreSQL table?

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

Also, 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 5 of 7" page of of SQL Server to PostgreSQL conversion wizard.

See Using Queries article for the further information.

Have more questions? Contact us