{"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fblog.kamipo.net%2Fentry%2F2014%2F10%2F27%2F184022\" title=\"MySQL\u30e6\u30fc\u30b6\u30fc\u306e\u305f\u3081\u306ePostgreSQL\u5bfe\u5fdc\u8868 - \u304b\u307f\u307d\u308f\u30fc\u308b\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","url":"https://blog.kamipo.net/entry/2014/10/27/184022","description":"\u6bce\u56de\u308f\u304b\u3089\u306a\u304f\u306a\u3063\u3066\u30b0\u30b0\u3063\u3066\u308b\u304b\u3089\u4eca\u5ea6\u304b\u3089\u3053\u3053\u306b\u8ffd\u8a18\u3057\u3066\u3044\u304f\u3002 MySQL PostgreSQL SHOW DATABASES; \\l USE dbname \\c dbname SHOW TABLES; \\dt SELECT * FROM tblname\\G \\x onSELECT * FROM tblname; SELECT * FROM information_schema.processlist; SELECT * FROM pg_stat_activity; KILL <pid>; SELECT pg_terminate_backend(pid); KILL QUERY <pid>; \u2026","width":"100%","blog_url":"https://blog.kamipo.net/","version":"1.0","author_url":"https://blog.hatena.ne.jp/kamipo/","image_url":null,"published":"2014-10-27 18:40:22","provider_name":"Hatena Blog","categories":[],"type":"rich","title":"MySQL\u30e6\u30fc\u30b6\u30fc\u306e\u305f\u3081\u306ePostgreSQL\u5bfe\u5fdc\u8868","height":"190","blog_title":"\u304b\u307f\u307d\u308f\u30fc\u308b","provider_url":"https://hatena.blog","author_name":"kamipo"}