Shulou(Shulou.com)05/31 Report--

This article mainly introduces the relevant knowledge of "how C++ connects to PostgreSQL database". The editor shows you the operation process through an actual case. The method of operation is simple, fast and practical. I hope this article "how C++ connects to PostgreSQL database" can help you solve the problem.

Installation

The latest version of libpqxx can be downloaded from the link: Libpqxx So download the latest version and follow these steps:

Wget http://pqxx.org/download/software/libpqxx/libpqxx-4.0.tar.gztar xvfz libpqxx-4.0.tar.gzcd libpqxx-4.0./configuremakemake install

Shell

Before you start using the PostgreSQL interface of Cmax Candle +, locate the pg_hba.conf file in the PostgreSQL installation directory and add the following line:

# IPv4 local connections:host all all 127.0.0.1/32 md5

Shell

You can start / restart the postgres server and run using the following command:

[root@host] # service postgresql restartStopping postgresql service: [OK] Starting postgresql service: [OK]

Shell

Connect to the PostgreSQL database with Candlespace +

The following C code snippet shows how to connect to an existing database running on the local machine on port 5432. Here, I use the backslash\ line to continue.

# include # include using namespace std;using namespace pqxx;int main (int argc, char* argv []) {try {connection C ("dbname=testdb user=postgres password=cohondob\ hostaddr=127.0.0.1 port=5432"); if (C.is_open ()) {cout

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.