From:       To:      

Home > Documentation > MySQL to PostgreSQL > FAQ

How to change the destination table name?

There are two approaches to modifying the destination table name. First option is to use Edit Table feature of MySQL to PostgreSQL converter. This feature can be accessed by double click on the corresponding table name in "Selected tables" list.

You can convert contents of the table as result of SELECT-query with custom name. Click "Add Query" button on "Select tables" wizard page and compose simple query as follows:

SELECT * FROM <original table name>

Then store it with the name you wish to assign. Of course, you need to place actual MySQL table name in the query above.

See Using Queries article for the further information.

Have more questions? Contact us