SQL in C++

How can one connect to an SQL database in a C++ program? like in PHP we have:

$cmd = "some SQL command";
$query = pg_query($cmd);
(for connecting to PostgreSQL)

Thanks.

EDIT: Ok, nevermind, just figured it out...