From:       To:      

Home > Documentation > SQLite to PostgreSQL

Edit Table in SQLite to PostgreSQL Converter

SQLite to PostgreSQL converter allows to rename tables or customize name, types and other attributes of every column as well as excluding a column from migration. The tool converts types in the most appropriate way. However, some migration projects may require customization of types mapping.

In order to customize migration of particular table, double-click on the corresponding selected item on "Select Tables" wizard page. Then the dialog box appears where you can modify table name, PostgreSQL type and default value for any columns using "Field info" group of controls. To exclude columns from resulting table just turn off the corresponding checkboxes.

Listview on the left of "Edit Table" dialog window displays original SQLite column attributes. PostgreSQL types and attributes are displayed in "Field info" section when the corresponding item is highlighted.

NOTE: inaccurate modification of table definitions may cause damage of the database (for example, loosing indexes or foreign keys).

Have any questions? Contact us