{"categories":["DataBase"],"author_name":"root-2004","url":"https://opentec.hateblo.jp/entry/2010/04/15/000000","blog_title":"OpenTecMemo \uff0f \u30aa\u30fc\u30d7\u30f3\u30c6\u30c3\u30af\u30e1\u30e2","title":"PostgreSQL SELECT INTO\u6587","type":"rich","author_url":"https://blog.hatena.ne.jp/root-2004/","version":"1.0","blog_url":"https://opentec.hateblo.jp/","provider_url":"https://hatena.blog","published":"2010-04-15 00:00:00","width":"100%","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fopentec.hateblo.jp%2Fentry%2F2010%2F04%2F15%2F000000\" title=\"PostgreSQL SELECT INTO\u6587 - OpenTecMemo \uff0f \u30aa\u30fc\u30d7\u30f3\u30c6\u30c3\u30af\u30e1\u30e2\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","height":"190","provider_name":"Hatena Blog","description":"\u3088\u304f\u5fd8\u308c\u308b\u306e\u3067\u30e1\u30e2\u3002 \u4f8b films\u30c6\u30fc\u30d6\u30eb\u306e\u6700\u8fd1\u306e\u9805\u76ee\u306e\u307f\u304b\u3089\u69cb\u6210\u3055\u308c\u308b\u3001\u65b0\u3057\u3044tmp_films_recent\u306e\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002 SELECT * INTO TEMPORARY tmp_films_recent FROM films WHERE date_prod >= '2002-01-01';","image_url":null}