{"categories":["Postgres","SQL"],"blog_title":"kikukawa's diary","author_name":"devillikeaangel","version":"1.0","published":"2009-09-07 16:09:12","author_url":"https://blog.hatena.ne.jp/devillikeaangel/","image_url":null,"title":"Postgres\u3067PrimaryKey\u306e\u5909\u66f4","width":"100%","provider_name":"Hatena Blog","description":"Postgres PRIMARY KEY \u5909\u66f4\u6bce\u56de\u8abf\u3079\u3066\u3044\u308b\u306e\u3067\u3001\u81ea\u5206\u7528\u30e1\u30e2PRIMARY KEY\u306e\u524a\u9664 ALTER TABLE table DROP CONSTRAINT table_pkey; PRIMARY KEY\u306e\u4f5c\u6210 ALTER TABLE table ADD CONSTRAINT table_key PRIMARY KEY(field1, field2); \u5f15\u7528\u5143\u30b5\u30a4\u30c8 http://yassu.jp/pukiwiki/index.php?PostgreSQL%B4%D8%CF%A2%A4%E1%A4%E2#ia977e20\u305d\u306e\u4ed6\u306e\u5b9a\u7fa9\u306f\u3053\u3061\u3089 kkkw.hatenablog.jp","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkkkw.hatenablog.jp%2Fentry%2F20090907%2F1252307352\" title=\"Postgres\u3067PrimaryKey\u306e\u5909\u66f4 - kikukawa&#39;s diary\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_url":"https://hatena.blog","type":"rich","height":"190","url":"https://kkkw.hatenablog.jp/entry/20090907/1252307352","blog_url":"https://kkkw.hatenablog.jp/"}