How To Install libpqtypes0-dbg on Debian 9

In this tutorial we learn how to install libpqtypes0-dbg on Debian 9. libpqtypes0-dbg is parameterized queries libpq extension - debug symbols

Introduction

In this tutorial we learn how to install libpqtypes0-dbg on Debian 9.

What is libpqtypes0-dbg

libpqtypes0-dbg is:

libpqtypes is a libpq extension that offers a new way of handling parameterized queries and getting result field values. Both putting parameters and getting values use a printf/scanf style interface, with consistent specifiers for both.

  • Full support for binary and text format. (parameter and result)
  • Full support for composites, arrays and composite arrays. (binary format only)
  • printf style interface to libpq’s binary parameterized API. (PQputf)
  • scanf style interface for getting values: PQgetvalue extension. (PQgetf)
  • Ability to register user-defined types, aliases and data type sub-classes for use with printf style interfaces: ex. “%mytype”.
  • Per-thread global error message. (PQgeterror)
  • Online docs as well as man pages.

This package contains the debug symbols.

There are three methods to install libpqtypes0-dbg on Debian 9. We can use apt-get, apt and aptitude. In the following sections we will describe each method. You can choose one of them.

Install libpqtypes0-dbg Using apt-get

Update apt database with apt-get using the following command.

sudo apt-get update

After updating apt database, We can install libpqtypes0-dbg using apt-get by running the following command:

sudo apt-get -y install libpqtypes0-dbg

Install libpqtypes0-dbg Using apt

Update apt database with apt using the following command.

sudo apt update

After updating apt database, We can install libpqtypes0-dbg using apt by running the following command:

sudo apt -y install libpqtypes0-dbg

Install libpqtypes0-dbg Using aptitude

If you want to follow this method, you might need to install aptitude first since aptitude is usually not installed by default on Debian. Update apt database with aptitude using the following command.

sudo aptitude update

After updating apt database, We can install libpqtypes0-dbg using aptitude by running the following command:

sudo aptitude -y install libpqtypes0-dbg

How To Uninstall libpqtypes0-dbg on Debian 9

To uninstall only the libpqtypes0-dbg package we can use the following command:

sudo apt-get remove libpqtypes0-dbg

Uninstall libpqtypes0-dbg And Its Dependencies

To uninstall libpqtypes0-dbg and its dependencies that are no longer needed by Debian 9, we can use the command below:

sudo apt-get -y autoremove libpqtypes0-dbg

Remove libpqtypes0-dbg Configurations and Data

To remove libpqtypes0-dbg configuration and data from Debian 9 we can use the following command:

sudo apt-get -y purge libpqtypes0-dbg

Remove libpqtypes0-dbg configuration, data, and all of its dependencies

We can use the following command to remove libpqtypes0-dbg configurations, data and all of its dependencies, we can use the following command:

sudo apt-get -y autoremove --purge libpqtypes0-dbg

Dependencies

libpqtypes0-dbg have the following dependencies:

References

Summary

In this tutorial we learn how to install libpqtypes0-dbg package on Debian 9 using different package management tools: apt, apt-get and aptitude.