PGModeler (http://www.pgmodeler.com.br) is a nice tool to design your (PostgreSQL) database. It supports import from and export to a databases. Ubuntu 15.10 comes with a quite recent version but e.g. Debian does not provide it in the repository. In this post I explain howto build the application on Linux (tested on Debian 8) from source.