{"version":"1.0","title":"PostgreSQL","image_url":null,"provider_url":"https://hatena.blog","url":"https://red-13.hateblo.jp/entry/20081012/1223820774","published":"2008-10-12 23:12:54","blog_url":"https://red-13.hateblo.jp/","width":"100%","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fred-13.hateblo.jp%2Fentry%2F20081012%2F1223820774\" title=\"PostgreSQL - \u3066\u304d\u3068\u3046\u306a\u304b\u3093\u3058\u3067\u30d7\u30ed\u30b0\u30e9\u30e0\u3068\u304b\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_title":"\u3066\u304d\u3068\u3046\u306a\u304b\u3093\u3058\u3067\u30d7\u30ed\u30b0\u30e9\u30e0\u3068\u304b","type":"rich","author_name":"red_13","height":"190","author_url":"https://blog.hatena.ne.jp/red_13/","categories":[],"description":"\u3068\u308a\u3042\u3048\u305a\uff0c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3068\u304b\u306fVine\u306eapt-get\u306a\u306e\u3067\uff0c\u7279\u306b\u96e3\u3057\u304f\u306a\u304f\u3066\uff0c\u305d\u308c\u3063\u307d\u3044\u306e\u3092apt-get install\u3057\u305f\u3060\u3051\uff0e \u3068\u308a\u3042\u3048\u305a\uff0c\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u308b\u3068\u3053\u308d\u307e\u3067\u3044\u3051\u3070\uff0c\u4ee5\u964d\u306fpsql\u3067\u64cd\u4f5c\u3067\u304d\u308b\uff0e \u306a\u3093\u304b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u304c\u304a\u304b\u3057\u3044\u6c17\u304c\u3059\u308b\u3051\u3069\uff0c\u307e\u3041\u3044\u3044\u3084\uff0e cd /var/lib/pgsql/ initdb data createdb postgres \u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u308b\uff0e psql postgres psql\u306e\u30b7\u30a7\u30eb\u304b\u3089\u30c6\u30fc\u30d6\u30eb\u3068\u304b\u30ec\u30b3\u30fc\u30c9\u3068\u304b\u3092\u64cd\u4f5c\u3059\u308b\uff0e \u307e\u305a\u306f\u30c6\u30fc\u30d6\u30eb\u3092\u8ffd\u52a0\uff0e create table test ( number int, name text ); \u2026","provider_name":"Hatena Blog"}