Home > Documentation > MySQL to PostgreSQL

Edit Table

This feature allows to rename table or customize name, types and other attributes of every column as well as exclude certain columns from conversion. MySQL to PostgreSQL converter maps types in the most intelligent way. However, sometimes it may be required to implement custom types mapping.

To customize migration of MySQL table, double-click on the corresponding selected item on "Select Tables" wizard page. In the appeared dialog box specify table name, type and default value for any columns using "Field info" group of controls. Also it is possible to exclude columns from conversion result by unchecking the corresponding checkbox.

Note: listview on the left of "Edit Table" dialog window contains column attributes for the original MySQL table, new types and attributes will be displayed in "Field info" controls when the corresponding item is highlighted in the listview.

Inaccurate modification of table structure may break the database integrity (for example, loosing indexes or foreign keys). Users should be very careful with "Edit Table" feature.