The missing PK, UK, FK, and Index can be added with few efforts with the reference in the following link. https://github.com/krgsoft/SQLtoPostgresMigrationScript.