{"id":51,"date":"2026-03-28T21:06:46","date_gmt":"2026-03-28T12:06:46","guid":{"rendered":"https:\/\/kabu-daisuki.com\/?p=51"},"modified":"2026-03-28T21:06:46","modified_gmt":"2026-03-28T12:06:46","slug":"wordpress%e3%81%a7-postgresql%e3%81%ab%e6%8e%a5%e7%b6%9a%e3%81%97%e3%81%a6%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92%e5%8f%96%e5%be%97%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/kabu-daisuki.com\/?p=51","title":{"rendered":"WordPress\u3067 Postgresql\u306b\u63a5\u7d9a\u3057\u3066\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b"},"content":{"rendered":"\n<p>WordPress\u306e\u30b5\u30a4\u30c8\u30da\u30fc\u30b8\u306b\u3001Postgresql\u306e\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3057\u3066\u8868\u793a\u3057\u305f\u3044\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">php-pgsql\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h2>\n\n\n\n<p>\u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3067PHP\u306ePostgres\u62e1\u5f35\u6a5f\u80fd\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3002<br>\u3053\u3046\u3059\u308b\u3068\u3001Postgres DB\u306b\u63a5\u7d9a\u3059\u308b\u305f\u3081\u306e\u30b3\u30de\u30f3\u30c9\u304c\u5229\u7528\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308b\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>yum install php-pgsql<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u30b5\u30a4\u30c8\u30da\u30fc\u30b8\u3067\u547c\u3073\u51fa\u3059<\/h2>\n\n\n\n<p>pg_connect\u306b\u63a5\u7d9a\u60c5\u5831\u3092\u6e21\u3059\u3068\u63a5\u7d9a\u3067\u304d\u308b\u3002\u63a5\u7d9a\u5f8c\u306fpg_query\u3067\u30af\u30a8\u30ea\u30fc\u3092\u6e21\u3059\u3068\u7d50\u679c\u304c\u5f97\u3089\u308c\u308b\u3002<br>\u305f\u3060\u3057\u3001\u3053\u306e\u7d50\u679c\u306b\u5bfe\u3057\u3066echo\u306a\u3069\u3057\u3066\u3082\u3001DB\u306e\u5185\u5bb9\u306f\u3048\u3089\u308c\u306a\u3044\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>       $connStr=sprintf(\n                \"host=%s port=5432 dbname=%s user=%s password=%s\",\n                getenv('PDBHOST'),\n                getenv('PDBNAME'),\n                getenv('PDBUSER'),\n                getenv('PDBPASS')\n        );\n\n        $db_connection=@pg_connect($connStr);\n        if (!$db_connection){\n                die('unable:'.(error_get_last()&#91;'message']??'unknown'));\n        }\n\n        $sql=\"SELECT * FROM nanntara\";\n        $res = pg_query($db_connection,$sql);\n\n        print_r($count);<\/code><\/pre>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>WordPress\u306e\u30b5\u30a4\u30c8\u30da\u30fc\u30b8\u306b\u3001Postgresql\u306e\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3057\u3066\u8868\u793a\u3057\u305f\u3044\u3002 php-pgsql\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb \u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3067PHP\u306ePostgres\u62e1\u5f35\u6a5f\u80fd\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3002\u3053\u3046\u3059\u308b\u3068\u3001Postgres D [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-51","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/kabu-daisuki.com\/index.php?rest_route=\/wp\/v2\/posts\/51","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kabu-daisuki.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kabu-daisuki.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kabu-daisuki.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kabu-daisuki.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=51"}],"version-history":[{"count":1,"href":"https:\/\/kabu-daisuki.com\/index.php?rest_route=\/wp\/v2\/posts\/51\/revisions"}],"predecessor-version":[{"id":52,"href":"https:\/\/kabu-daisuki.com\/index.php?rest_route=\/wp\/v2\/posts\/51\/revisions\/52"}],"wp:attachment":[{"href":"https:\/\/kabu-daisuki.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=51"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kabu-daisuki.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=51"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kabu-daisuki.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=51"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}