{"published":"2025-05-01 21:00:00","provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/BG1/","provider_url":"https://hatena.blog","title":"\u7279\u6b8a\u6587\u5b57\u30a2\u30b9\u30bf\u30ea\u30b9\u30af('*')","blog_url":"https://bg1.hatenablog.com/","blog_title":"\u8eca\u8f2a\u306ex\u767a\u660e ~B.G's Blog~","image_url":null,"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fbg1.hatenablog.com%2Fentry%2F2025%2F05%2F01%2F210000\" title=\"\u7279\u6b8a\u6587\u5b57\u30a2\u30b9\u30bf\u30ea\u30b9\u30af(&#39;*&#39;) - \u8eca\u8f2a\u306ex\u767a\u660e ~B.G&#39;s Blog~\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_name":"BG1","width":"100%","url":"https://bg1.hatenablog.com/entry/2025/05/01/210000","type":"rich","categories":["PostgreSQL"],"version":"1.0","height":"190","description":"\u7279\u6b8a\u6587\u5b57\u30a2\u30b9\u30bf\u30ea\u30b9\u30af('*')\u306f\u3001SELECT\u3084COUNT\u3067\u300c\u3059\u3079\u3066\u306e\uff5e\u300d\u3068\u3044\u3046\u610f\u5473\u3092\u6307\u3059\u3002https://www.postgresql.jp/document/7.2/user/sql-syntax.html postgresdb1=# CREATE TABLE profile (name varchar(32), address varchar(256), age integer); CREATE TABLE postgresdb1=# INSERT INTO profile (name, address, age) VALUES ('Taro', 'Tokyo', 30); INSERT\u2026"}