To get the latest version of PostgreSQL Schema, simply require "thibaud-dauce/postgresql-schema": "1.*" in your composer.json file. You'll then need to run composer install or composer update to download it and have the autoloader updated.
Once PostgreSQL Schema is installed, you need to register the service provider. Open up app/config/app.php and add the following to the providers key.