{"author_name":"bayan","published":"2012-04-05 06:11:52","author_url":"https://blog.hatena.ne.jp/bayan/","title":"\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u540d\u524d\u3092\u5909\u66f4\u3057\u3066\u307f\u305f - PostgreSQL","provider_url":"https://hatena.blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fbayan.hatenadiary.com%2Fentry%2F20120405%2F1333573912\" title=\"\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u540d\u524d\u3092\u5909\u66f4\u3057\u3066\u307f\u305f - PostgreSQL - 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>","categories":["PostgreSQL"],"type":"rich","height":"190","width":"100%","url":"https://bayan.hatenadiary.com/entry/20120405/1333573912","blog_title":"bayan\u306e<del>\u96fb\u6ce2</del>\u65e5\u8a18","description":"ALTER DATABASE \u3067\u3067\u304d\u308b\u3002 ALTER DATABASE hoge_db RENAME TO foo_db; \u30ea\u30cd\u30fc\u30e0\u5bfe\u8c61\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u3057\u3066\u3044\u308b\u3068\u30c0\u30e1\u3068\u8a00\u308f\u308c\u308b\u3002 hoge_db=# ALTER DATABASE hoge_db RENAME TO hoge_db_bak; ERROR: current database may not be renamed\u30ea\u30cd\u30fc\u30e0\u5bfe\u8c61\u4ee5\u5916\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u3057\u3066\u64cd\u4f5c\u3092\u884c\u3046\u3002 template1 \u3067\u3044\u3044\u3068\u601d\u3046\u3002 [dareka@dokka ~]$ psql template1 Welcome to psql 8.1.11, the Post\u2026","image_url":null,"blog_url":"https://bayan.hatenadiary.com/","provider_name":"Hatena Blog","version":"1.0"}