The postgres API is gross...

postgres-nonsense.cpp

#include <libpq-fe.h>
#include <iostream>
using namespace std;

int main(int argc, char** argv)
{
    PGconn* connection = PQconnectdb(
        "host=localhost port=5432 dbname=swccg user=postgres");
    
    if (PQstatus(connection) == CONNECTION_OK)
    {
        PGresult* result = PQexec(connection, "SELECT * FROM legacy_card_info");
        
        cout << PQntuples(result) << " rows" << endl;
        cout << PQnfields(result) << " columns" << endl;
        
        PQclear(result);
    }
    else
    {
        cerr << PQerrorMessage(connection) << '\n';
    }
        
    
    PQfinish(connection);
    return 0;
}