How to convert a Microsoft SQL Server CE file (.sdf) to Postgres 9.6 /pgAdmin 4?
You can use my tools to script data and schema as SQL Server compatible scripts, and if required tweak those to run with Postgress: http://erikej.github.io/SqlCeToolbox/