{"id":220,"date":"2026-02-11T17:33:40","date_gmt":"2026-02-11T17:33:40","guid":{"rendered":"https:\/\/www.hokutotokisama.fr\/?p=220"},"modified":"2026-02-11T17:34:05","modified_gmt":"2026-02-11T17:34:05","slug":"se-connecter-a-une-base-postgresql-en-ligne-de-commande","status":"publish","type":"post","link":"https:\/\/www.hokutotokisama.fr\/?p=220","title":{"rendered":"Se connecter \u00e0 une base PostgreSQL en ligne de commande"},"content":{"rendered":"\n<p>Pour se connecter \u00e0 une base PostgreSQL en ligne de commande c&rsquo;est tr\u00e8s simple<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>on passe en utilisateur qui est administrateur de PostgreSQL (postgres dans notre exemple)<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo -i -u postgres<\/code><\/pre>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a05ffd38a03a&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a05ffd38a03a\" class=\"wp-block-image size-full wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"478\" height=\"58\" 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-11-182925.png\" alt=\"\" class=\"wp-image-221\" srcset=\"https:\/\/www.hokutotokisama.fr\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-11-182925.png 478w, https:\/\/www.hokutotokisama.fr\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-11-182925-300x36.png 300w\" sizes=\"auto, (max-width: 478px) 100vw, 478px\" \/><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<ul class=\"wp-block-list\">\n<li>on se mets en mode sql<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>psql<\/code><\/pre>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a05ffd38a387&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a05ffd38a387\" class=\"wp-block-image size-full wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"542\" height=\"120\" 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-11-183014.png\" alt=\"\" class=\"wp-image-222\" srcset=\"https:\/\/www.hokutotokisama.fr\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-11-183014.png 542w, https:\/\/www.hokutotokisama.fr\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-11-183014-300x66.png 300w\" sizes=\"auto, (max-width: 542px) 100vw, 542px\" \/><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<ul class=\"wp-block-list\">\n<li>on se connecte \u00e0 la base<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>\\c nomdelabase<\/code><\/pre>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a05ffd38a668&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a05ffd38a668\" class=\"wp-block-image size-full wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"805\" height=\"89\" 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-11-183114.png\" alt=\"\" class=\"wp-image-223\" srcset=\"https:\/\/www.hokutotokisama.fr\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-11-183114.png 805w, https:\/\/www.hokutotokisama.fr\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-11-183114-300x33.png 300w, https:\/\/www.hokutotokisama.fr\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-11-183114-768x85.png 768w\" sizes=\"auto, (max-width: 805px) 100vw, 805px\" \/><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<ul class=\"wp-block-list\">\n<li>on peux taper toutes les commandes sql que l&rsquo;on veux<\/li>\n<\/ul>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a05ffd38a8e1&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a05ffd38a8e1\" class=\"wp-block-image size-full wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"919\" height=\"119\" 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-11-183259.png\" alt=\"\" class=\"wp-image-224\" srcset=\"https:\/\/www.hokutotokisama.fr\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-11-183259.png 919w, https:\/\/www.hokutotokisama.fr\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-11-183259-300x39.png 300w, https:\/\/www.hokutotokisama.fr\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-11-183259-768x99.png 768w\" sizes=\"auto, (max-width: 919px) 100vw, 919px\" \/><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><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pour se connecter \u00e0 une base PostgreSQL en ligne de commande c&rsquo;est tr\u00e8s simple<\/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":[28,23],"class_list":["post-220","post","type-post","status-publish","format-standard","hentry","category-base-de-donnees","tag-postgresql","tag-sql"],"_links":{"self":[{"href":"https:\/\/www.hokutotokisama.fr\/index.php?rest_route=\/wp\/v2\/posts\/220","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=220"}],"version-history":[{"count":1,"href":"https:\/\/www.hokutotokisama.fr\/index.php?rest_route=\/wp\/v2\/posts\/220\/revisions"}],"predecessor-version":[{"id":225,"href":"https:\/\/www.hokutotokisama.fr\/index.php?rest_route=\/wp\/v2\/posts\/220\/revisions\/225"}],"wp:attachment":[{"href":"https:\/\/www.hokutotokisama.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=220"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hokutotokisama.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=220"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hokutotokisama.fr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=220"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}