postgresql

passwprd:123456port:5432

1、linux 命令行连接  

>su –postgres

>psql

>\list  \l                            //list database

 

>\c testdb                 //connect to testdb

>\d                    //list all table

>\d campany //list the table campany

2、c++ 程序中 通过libpq libpqxx操作

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

using namespace std;
using namespace pqxx;

int connect()
{
	
	try
	{	string dst="dbname="+db_name+" user="+db_username+" password="+db_password+" hostaddr="+db_server + " port="+db_port;
		cout<<"pqxx::connection conn"<<endl;
		
		conn=new pqxx::connection(dst);

		cout<<"Psql connect"<<endl;
		if(conn->is_open())
		{
			std::cout<< "opened database successfully " << conn->dbname()<<endl;
			std::cout << conn->options()<<std::endl; 
			//return 0;
		}
		else
		{
			cout<<"can not open database"<<endl;
			return -1;
		}	
		//conn->disconnect();
	}
	catch (const exception& ex)
	{
		cerr<<ex.what()<<endl;
		return -1;
	}
	cout <<"conn = "<<conn<<endl;
	return 0;
	
}