如何在qt creator中使用libpqxx

sudo apt-get install libpqxx-dev

LIBS += -lpqxx

#include <pqxx/pqxx>
#include <iostream>

int main() {
    try {
        pqxx::connection conn("dbname=test user=postgres password=postgres \
                              hostaddr=127.0.0.1 port=5432");

        if (conn.is_open()) {
            std::cout << "Connected to PostgreSQL!" << std::endl;

            pqxx::work txn(conn);

            pqxx::result result = txn.exec("SELECT * FROM my_table");

            for (pqxx::result::const_iterator row = result.begin(); row != result.end(); ++row) {
                std::cout << "Value: " << row[0].as<std::string>() << std::endl;
            }

            txn.commit();
        }

        conn.disconnect();
    } catch (const std::exception& e) {
        std::cerr << e.what() << std::endl;
        return 1;
    }

    return 0;
}