Home > Documentation > PostgreSQL to MySQL

Edit Table

PostgreSQL to MySQL converter maps types in the most appropriate way. However, some database migration tasks may require custom types mapping. The tool allows edit table structure that includes renamng table, customizing name, types and other attributes of every column as well as exclude certain columns from conversion.

To edit a table, double-click on the appropriate item in selected tables listbox of "Select Tables" page. Then the dialog box appears to specify table name, type and default value for every field 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 PostgreSQL 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.