{"published":"2016-10-28 00:00:01","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fbayan.hatenadiary.com%2Fentry%2F20161028%2Fp2\" title=\"SQL\u3067\u5909\u6570\u3092\u4f7f\u3063\u3066\u307f\u308b - bayan\u306e&lt;del&gt;\u96fb\u6ce2&lt;/del&gt;\u65e5\u8a18\" 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":"bayan\u306e<del>\u96fb\u6ce2</del>\u65e5\u8a18","author_name":"bayan","author_url":"https://blog.hatena.ne.jp/bayan/","type":"rich","categories":[],"version":"1.0","image_url":null,"provider_name":"Hatena Blog","title":"SQL\u3067\u5909\u6570\u3092\u4f7f\u3063\u3066\u307f\u308b","description":"PostgreSQL psql \u30c6\u30b9\u30c8\u30c7\u30fc\u30bf test=> SELECT * FROM pan; id | name ----+------------ 1 | \u30a2\u30f3\u30d1\u30f3 2 | \u98df\u30d1\u30f3 3 | \u30ab\u30ec\u30fc\u30d1\u30f3 (3 rows)\u4ee3\u5165\u3002\\set \u540d\u524d \u5024 test=> \\set id 1\\echo\u3067\u8868\u793a\u3057\u3066\u307f\u308b\u3002 1\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u3002 test=> \\echo :id 1SQL\u306e\u4e2d\u3067\u4f7f\u3063\u3066\u307f\u308b\u3002 test=> SELECT * FROM pan WHERE id = :id; id | name ----+---------- 1 | \u30a2\u30f3\u30d1\u30f3 (1 row)","provider_url":"https://hatena.blog","width":"100%","height":"190","blog_url":"https://bayan.hatenadiary.com/","url":"https://bayan.hatenadiary.com/entry/20161028/p2"}