You can uninstall or removes an installed pdns-backend-pgsql package itself from Ubuntu 14.04 LTS (Trusty Tahr) through the terminal,
$ sudo apt-get remove pdns-backend-pgsql
If you would like to remove pdns-backend-pgsql and it's dependent packages which are no longer needed from Ubuntu,
$ sudo apt-get remove --auto-remove pdns-backend-pgsql
If you use with purge options to pdns-backend-pgsql package all the configuration and dependent packages will be removed.
$ sudo apt-get purge pdns-backend-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 pdns-backend-pgsql