You can uninstall or removes an installed libdbd-pgsql package itself from Debian 8 (Jessie) through the terminal,
$ sudo apt-get remove libdbd-pgsql
If you would like to remove libdbd-pgsql and it's dependent packages which are no longer needed from Ubuntu,
$ sudo apt-get remove --auto-remove libdbd-pgsql
If you use with purge options to libdbd-pgsql package all the configuration and dependent packages will be removed.
$ sudo apt-get purge libdbd-pgsql
If you use purge options along with auto remove, will be removed everything regarding the package, It's really useful when you want to reinstall again.
$ sudo apt-get purge --auto-remove libdbd-pgsql