From:       To:      

Home > Documentation > MySQL to PostgreSQL > FAQ

Why some indexes are created with "00000", "00001", ... suffixes added to the name?

This is to make index name unique. While MySQL allows different tables to have indexes with the same name, PostreSQL requires index name to be unique across the entire database.

Have more questions? Contact us