To remove just pdns-backend-pgsql package itself from Debian Unstable (Sid) execute on terminal:
sudo apt-get remove pdns-backend-pgsql
Uninstall pdns-backend-pgsql and it's dependent packages
To remove the pdns-backend-pgsql package and any other dependant package which are no longer needed from Debian Sid.
sudo apt-get remove --auto-remove pdns-backend-pgsql
If you also want to delete configuration and/or data files of pdns-backend-pgsql from Debian Sid then this will work:
sudo apt-get purge pdns-backend-pgsql
To delete configuration and/or data files of pdns-backend-pgsql and it's dependencies from Debian Sid then execute:
sudo apt-get purge --auto-remove pdns-backend-pgsql
More information about apt-get remove
apt-get remove is identical to install except that packages are removed instead of installed. Note that removing a package leaves its configuration files on the system. If a plus sign is appended to the package name (with no intervening space), the identified package will be installed instead of removed.