php连接postgresql和操作

        $host        = "host=127.0.0.1";
        $port        = "port=90019";
        $dbname      = "dbname=z222o";
        $credentials = "user=z222o password=itPs38ZCxfs7";

        $db = pg_connect( "$host $port $dbname $credentials");

        $result = pg_query($db, "select * from cdj_order_95");
        print_r(pg_fetch_all($result));

宝塔安装

pgsql

通用扩展

php官方扩展(需提前安装postgresql)

开启

extension=pdo_pgsql
extension=pgsql

查询
$result = pg_query($db, "select * from cdj_order_95");
print_r(pg_fetch_all($result));

插入
$newrow=array("pindex_id"=>"10067");
$reusult=pg_insert($db,"cdj_order_95",$newrow);

修改
$newrow=array(
            "pindex_id"=>"10067"
);
$reusult=pg_update($db,"cdj_order_95",$newrow,['id'=>5]);

删除
$reusult=pg_delete($db,"cdj_order_95",['id'=>5]);