{"id":202,"date":"2026-02-10T15:40:44","date_gmt":"2026-02-10T15:40:44","guid":{"rendered":"https:\/\/www.hokutotokisama.fr\/?p=202"},"modified":"2026-02-10T15:45:56","modified_gmt":"2026-02-10T15:45:56","slug":"mettre-une-colonne-en-autoincrement-sur-pgadmin","status":"publish","type":"post","link":"https:\/\/www.hokutotokisama.fr\/?p=202","title":{"rendered":"Mettre une colonne en AutoIncrement sur PGAdmin"},"content":{"rendered":"\n<p>Sur PGAdmin ce n&rsquo;est pas aussi simple que sur PhpMyAdmin pour mettre une colonne en autoincrement<\/p>\n\n\n\n<p>Pour faire \u00e7a il faut<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>cr\u00e9er la colonne<\/li>\n\n\n\n<li>Lui mettre un nom<\/li>\n\n\n\n<li>Type de donn\u00e9es en Integer<\/li>\n\n\n\n<li>Cocher Not Null<\/li>\n\n\n\n<li>Cliquer sur le petit stylo \u00e0 gauche pour modifier<\/li>\n\n\n\n<li>Aller dans contraintes<\/li>\n\n\n\n<li>Type : mettre identit\u00e9<\/li>\n\n\n\n<li>Dans Identit\u00e9 mettre : par d\u00e9faut<\/li>\n<\/ul>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a05f4d48a2a1&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a05f4d48a2a1\" class=\"wp-block-image size-large wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"621\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/www.hokutotokisama.fr\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-10-163726-1024x621.png\" alt=\"\" class=\"wp-image-203\" srcset=\"https:\/\/www.hokutotokisama.fr\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-10-163726-1024x621.png 1024w, https:\/\/www.hokutotokisama.fr\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-10-163726-300x182.png 300w, https:\/\/www.hokutotokisama.fr\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-10-163726-768x466.png 768w, https:\/\/www.hokutotokisama.fr\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-10-163726.png 1114w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\taria-label=\"Agrandir\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.imageButtonRight\"\n\t\t\tdata-wp-style--top=\"state.imageButtonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<p><strong>Attention<\/strong><\/p>\n\n\n\n<p>Si on fais \u00e7a apr\u00e8s avoir mis des donn\u00e9es il faut aller dans \u00ab\u00a0d\u00e9but\u00a0\u00bb puis forcer le d\u00e9but \u00e0 la derni\u00e8re valeur rentr\u00e9e+1<\/p>\n\n\n\n<p>Par d\u00e9faut : quand on coche l&rsquo;autoincrement, PGAdmin mets le d\u00e9but \u00e0 1 et donc on se retrouve avec une erreur d&rsquo;int\u00e9grit\u00e9 si on a d\u00e9j\u00e0 des donn\u00e9es<\/p>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a05f4d48a58a&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a05f4d48a58a\" class=\"wp-block-image size-large wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"622\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/www.hokutotokisama.fr\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-10-163929-1024x622.png\" alt=\"\" class=\"wp-image-204\" srcset=\"https:\/\/www.hokutotokisama.fr\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-10-163929-1024x622.png 1024w, https:\/\/www.hokutotokisama.fr\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-10-163929-300x182.png 300w, https:\/\/www.hokutotokisama.fr\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-10-163929-768x467.png 768w, https:\/\/www.hokutotokisama.fr\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-10-163929.png 1101w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\taria-label=\"Agrandir\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.imageButtonRight\"\n\t\t\tdata-wp-style--top=\"state.imageButtonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Sur PGAdmin ce n&rsquo;est pas aussi simple que sur PhpMyAdmin pour mettre une colonne en autoincrement Pour faire \u00e7a il faut Attention Si on fais \u00e7a apr\u00e8s avoir mis des donn\u00e9es il faut aller dans \u00ab\u00a0d\u00e9but\u00a0\u00bb puis forcer le d\u00e9but \u00e0 la derni\u00e8re valeur rentr\u00e9e+1 Par d\u00e9faut : quand on coche l&rsquo;autoincrement, PGAdmin mets le [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27],"tags":[29,28,23],"class_list":["post-202","post","type-post","status-publish","format-standard","hentry","category-base-de-donnees","tag-pgadmin","tag-postgresql","tag-sql"],"_links":{"self":[{"href":"https:\/\/www.hokutotokisama.fr\/index.php?rest_route=\/wp\/v2\/posts\/202","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hokutotokisama.fr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hokutotokisama.fr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hokutotokisama.fr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hokutotokisama.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=202"}],"version-history":[{"count":2,"href":"https:\/\/www.hokutotokisama.fr\/index.php?rest_route=\/wp\/v2\/posts\/202\/revisions"}],"predecessor-version":[{"id":206,"href":"https:\/\/www.hokutotokisama.fr\/index.php?rest_route=\/wp\/v2\/posts\/202\/revisions\/206"}],"wp:attachment":[{"href":"https:\/\/www.hokutotokisama.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hokutotokisama.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=202"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hokutotokisama.fr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}