https://nl-wiki.ikoula.com/index.php?action=history&feed=atom&title=Een_PostgreSQL_database_maken 2026-11-10T21:54:15Z Bewerkingsoverzicht voor deze pagina op de wiki MediaWiki 1.35.3 https://nl-wiki.ikoula.com/index.php?title=Een_PostgreSQL_database_maken&diff=12574&oldid=prev 2021-10-21T08:47:40Z

<p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="nl"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Oudere versie</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Versie van 21 okt 2021 08:47</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l12" >Regel 12:</td> <td colspan="2" class="diff-lineno">Regel 12:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate_en_title=&quot;Creating a PostgreSQL database&quot;  data-link_translate_en_url=&quot;Creating a PostgreSQL database&quot;&gt;&lt;/span&gt;[[:en:Creating a PostgreSQL database]][[en:Creating a PostgreSQL database]]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate_en_title=&quot;Creating a PostgreSQL database&quot;  data-link_translate_en_url=&quot;Creating a PostgreSQL database&quot;&gt;&lt;/span&gt;[[:en:Creating a PostgreSQL database]][[en:Creating a PostgreSQL database]]</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ro&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ru&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ja&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ar&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;zh&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;de&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;nl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;it&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pt&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;es&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ro&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ru&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ja&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ar&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;zh&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;de&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;nl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;it&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pt&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;es&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;en&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ro&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ru&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ja&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ar&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;zh&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;de&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;nl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;it&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pt&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;es&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;en&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ro&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ru&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ja&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ar&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;zh&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;de&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;nl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;it&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pt&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;es&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;en&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ro&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ru&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ja&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ar&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;zh&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;de&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;nl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;it&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pt&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;es&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;en&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ro&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ru&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ja&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ar&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;zh&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;de&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;nl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;it&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pt&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;es&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;en&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ro&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ru&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ja&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ar&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;zh&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ro&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;de&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;nl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;it&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pt&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;es&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;en&quot;&gt;&lt;/span&gt;&lt;!-- Début de l'article. Placez votre texte ci-après et n'hésitez pas à personnaliser les chapitres selon votre besoin --&gt;</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ro&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ru&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ja&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ar&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;zh&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;de&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;nl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;it&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pt&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;es&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ro&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ru&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ja&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ar&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;zh&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;de&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;nl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;it&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pt&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;es&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;en&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ro&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ru&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ja&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ar&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;zh&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;de&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;nl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;it&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pt&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;es&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;en&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ro&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ru&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ja&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ar&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;zh&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;de&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;nl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;it&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pt&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;es&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;en&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ro&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ru&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ja&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ar&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;zh&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;de&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;nl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;it&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pt&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;es&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;en&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ro&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ru&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ja&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ar&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;zh&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;de&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;nl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;it&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pt&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;es&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;en&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ro&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ru&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ja&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ar&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;zh&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ro&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;de&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;nl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;it&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pt&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;es&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;en&quot;&gt;&lt;/span&gt;&lt;!-- Début de l'article. Placez votre texte ci-après et n'hésitez pas à personnaliser les chapitres selon votre besoin --&gt;</div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">{{#seo:</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|title=Een PostgreSQL database maken</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|title_mode=append</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|keywords=these,are,your,keywords</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|description=Een PostgreSQL database maken</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|image=Uploaded_file.png</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|image_alt=Wiki Logo</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">}}</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Inleiding==</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Inleiding==</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l17" >Regel 17:</td> <td colspan="2" class="diff-lineno">Regel 26:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Verbinding maken met PostgreSQL==</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Verbinding maken met PostgreSQL==</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>We gaan onder de gebruiker '''postgres''' gebruiker, dan maken we verbinding met PostgreSQL :</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>We gaan onder de gebruiker '''postgres''' gebruiker, dan maken we verbinding met <ins class="diffchange diffchange-inline">[https://www.ikoula.nl/nl/public-cloud/oneclick/postgresql </ins>PostgreSQL<ins class="diffchange diffchange-inline">] </ins>:</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;syntaxhighlight lang=&quot;bash&quot;&gt;</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;syntaxhighlight lang=&quot;bash&quot;&gt;</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># su - postgres</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># su - postgres</div></td></tr> <!-- diff cache key nl_ikwiki-ik_:diff::1.12:old-12400:rev-12574 --> </table>

Cbrochot1072d https://nl-wiki.ikoula.com/index.php?title=Een_PostgreSQL_database_maken&diff=12400&oldid=prev 2021-07-29T10:50:45Z

<p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="nl"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Oudere versie</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Versie van 29 jul 2021 10:50</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Regel 1:</td> <td colspan="2" class="diff-lineno">Regel 1:</td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;span data-link_translate_ro_title=&quot;Crearea unei baze de date PostgreSQL&quot;  data-link_translate_ro_url=&quot;Crearea unei baze de date PostgreSQL&quot;&gt;&lt;/span&gt;[[:ro:Crearea unei baze de date PostgreSQL]][[ro:Crearea unei baze de date PostgreSQL]]</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate_ru_title=&quot;Создание базы данных PostgreSQL&quot;  data-link_translate_ru_url=&quot;Создание базы данных PostgreSQL&quot;&gt;&lt;/span&gt;[[:ru:Создание базы данных PostgreSQL]][[ru:Создание базы данных PostgreSQL]]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate_ru_title=&quot;Создание базы данных PostgreSQL&quot;  data-link_translate_ru_url=&quot;Создание базы данных PostgreSQL&quot;&gt;&lt;/span&gt;[[:ru:Создание базы данных PostgreSQL]][[ru:Создание базы данных PostgreSQL]]</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate_pl_title=&quot;Tworzenie bazy danych PostgreSQL&quot;  data-link_translate_pl_url=&quot;Tworzenie bazy danych PostgreSQL&quot;&gt;&lt;/span&gt;[[:pl:Tworzenie bazy danych PostgreSQL]][[pl:Tworzenie bazy danych PostgreSQL]]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate_pl_title=&quot;Tworzenie bazy danych PostgreSQL&quot;  data-link_translate_pl_url=&quot;Tworzenie bazy danych PostgreSQL&quot;&gt;&lt;/span&gt;[[:pl:Tworzenie bazy danych PostgreSQL]][[pl:Tworzenie bazy danych PostgreSQL]]</div></td></tr> <!-- diff cache key nl_ikwiki-ik_:diff::1.12:old-12399:rev-12400 --> </table>

Ikbot https://nl-wiki.ikoula.com/index.php?title=Een_PostgreSQL_database_maken&diff=12399&oldid=prev 2021-07-29T10:49:31Z

<p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="nl"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Oudere versie</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Versie van 29 jul 2021 10:49</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Regel 1:</td> <td colspan="2" class="diff-lineno">Regel 1:</td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;span data-link_translate_ru_title=&quot;Создание базы данных PostgreSQL&quot;  data-link_translate_ru_url=&quot;Создание базы данных PostgreSQL&quot;&gt;&lt;/span&gt;[[:ru:Создание базы данных PostgreSQL]][[ru:Создание базы данных PostgreSQL]]</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate_pl_title=&quot;Tworzenie bazy danych PostgreSQL&quot;  data-link_translate_pl_url=&quot;Tworzenie bazy danych PostgreSQL&quot;&gt;&lt;/span&gt;[[:pl:Tworzenie bazy danych PostgreSQL]][[pl:Tworzenie bazy danych PostgreSQL]]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate_pl_title=&quot;Tworzenie bazy danych PostgreSQL&quot;  data-link_translate_pl_url=&quot;Tworzenie bazy danych PostgreSQL&quot;&gt;&lt;/span&gt;[[:pl:Tworzenie bazy danych PostgreSQL]][[pl:Tworzenie bazy danych PostgreSQL]]</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate_ja_title=&quot;PostgreSQLデータベースの作成&quot;  data-link_translate_ja_url=&quot;PostgreSQLデータベースの作成&quot;&gt;&lt;/span&gt;[[:ja:PostgreSQLデータベースの作成]][[ja:PostgreSQLデータベースの作成]]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate_ja_title=&quot;PostgreSQLデータベースの作成&quot;  data-link_translate_ja_url=&quot;PostgreSQLデータベースの作成&quot;&gt;&lt;/span&gt;[[:ja:PostgreSQLデータベースの作成]][[ja:PostgreSQLデータベースの作成]]</div></td></tr> <!-- diff cache key nl_ikwiki-ik_:diff::1.12:old-12398:rev-12399 --> </table>

Ikbot https://nl-wiki.ikoula.com/index.php?title=Een_PostgreSQL_database_maken&diff=12398&oldid=prev 2021-07-29T10:48:25Z

<p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="nl"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Oudere versie</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Versie van 29 jul 2021 10:48</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Regel 1:</td> <td colspan="2" class="diff-lineno">Regel 1:</td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;span data-link_translate_pl_title=&quot;Tworzenie bazy danych PostgreSQL&quot;  data-link_translate_pl_url=&quot;Tworzenie bazy danych PostgreSQL&quot;&gt;&lt;/span&gt;[[:pl:Tworzenie bazy danych PostgreSQL]][[pl:Tworzenie bazy danych PostgreSQL]]</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate_ja_title=&quot;PostgreSQLデータベースの作成&quot;  data-link_translate_ja_url=&quot;PostgreSQLデータベースの作成&quot;&gt;&lt;/span&gt;[[:ja:PostgreSQLデータベースの作成]][[ja:PostgreSQLデータベースの作成]]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate_ja_title=&quot;PostgreSQLデータベースの作成&quot;  data-link_translate_ja_url=&quot;PostgreSQLデータベースの作成&quot;&gt;&lt;/span&gt;[[:ja:PostgreSQLデータベースの作成]][[ja:PostgreSQLデータベースの作成]]</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate_zh_title=&quot;创建一个PostgreSQL数据库&quot;  data-link_translate_zh_url=&quot;创建一个PostgreSQL数据库&quot;&gt;&lt;/span&gt;[[:zh:创建一个PostgreSQL数据库]][[zh:创建一个PostgreSQL数据库]]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate_zh_title=&quot;创建一个PostgreSQL数据库&quot;  data-link_translate_zh_url=&quot;创建一个PostgreSQL数据库&quot;&gt;&lt;/span&gt;[[:zh:创建一个PostgreSQL数据库]][[zh:创建一个PostgreSQL数据库]]</div></td></tr> <!-- diff cache key nl_ikwiki-ik_:diff::1.12:old-12397:rev-12398 --> </table>

Ikbot https://nl-wiki.ikoula.com/index.php?title=Een_PostgreSQL_database_maken&diff=12397&oldid=prev 2021-07-29T10:47:17Z

<p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="nl"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Oudere versie</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Versie van 29 jul 2021 10:47</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Regel 1:</td> <td colspan="2" class="diff-lineno">Regel 1:</td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;span data-link_translate_ja_title=&quot;PostgreSQLデータベースの作成&quot;  data-link_translate_ja_url=&quot;PostgreSQLデータベースの作成&quot;&gt;&lt;/span&gt;[[:ja:PostgreSQLデータベースの作成]][[ja:PostgreSQLデータベースの作成]]</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate_zh_title=&quot;创建一个PostgreSQL数据库&quot;  data-link_translate_zh_url=&quot;创建一个PostgreSQL数据库&quot;&gt;&lt;/span&gt;[[:zh:创建一个PostgreSQL数据库]][[zh:创建一个PostgreSQL数据库]]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate_zh_title=&quot;创建一个PostgreSQL数据库&quot;  data-link_translate_zh_url=&quot;创建一个PostgreSQL数据库&quot;&gt;&lt;/span&gt;[[:zh:创建一个PostgreSQL数据库]][[zh:创建一个PostgreSQL数据库]]</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate_de_title=&quot;Erstellen einer PostgreSQL-Datenbank&quot;  data-link_translate_de_url=&quot;Erstellen einer PostgreSQL-Datenbank&quot;&gt;&lt;/span&gt;[[:de:Erstellen einer PostgreSQL-Datenbank]][[de:Erstellen einer PostgreSQL-Datenbank]]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate_de_title=&quot;Erstellen einer PostgreSQL-Datenbank&quot;  data-link_translate_de_url=&quot;Erstellen einer PostgreSQL-Datenbank&quot;&gt;&lt;/span&gt;[[:de:Erstellen einer PostgreSQL-Datenbank]][[de:Erstellen einer PostgreSQL-Datenbank]]</div></td></tr> <!-- diff cache key nl_ikwiki-ik_:diff::1.12:old-12396:rev-12397 --> </table>

Ikbot https://nl-wiki.ikoula.com/index.php?title=Een_PostgreSQL_database_maken&diff=12396&oldid=prev 2021-07-29T10:45:57Z

<p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="nl"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Oudere versie</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Versie van 29 jul 2021 10:45</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Regel 1:</td> <td colspan="2" class="diff-lineno">Regel 1:</td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;span data-link_translate_zh_title=&quot;创建一个PostgreSQL数据库&quot;  data-link_translate_zh_url=&quot;创建一个PostgreSQL数据库&quot;&gt;&lt;/span&gt;[[:zh:创建一个PostgreSQL数据库]][[zh:创建一个PostgreSQL数据库]]</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate_de_title=&quot;Erstellen einer PostgreSQL-Datenbank&quot;  data-link_translate_de_url=&quot;Erstellen einer PostgreSQL-Datenbank&quot;&gt;&lt;/span&gt;[[:de:Erstellen einer PostgreSQL-Datenbank]][[de:Erstellen einer PostgreSQL-Datenbank]]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate_de_title=&quot;Erstellen einer PostgreSQL-Datenbank&quot;  data-link_translate_de_url=&quot;Erstellen einer PostgreSQL-Datenbank&quot;&gt;&lt;/span&gt;[[:de:Erstellen einer PostgreSQL-Datenbank]][[de:Erstellen einer PostgreSQL-Datenbank]]</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate_fr_title=&quot;Créer une base de donnés PostgreSQL&quot;  data-link_translate_fr_url=&quot;Créer une base de donnés PostgreSQL&quot;&gt;&lt;/span&gt;[[:fr:Créer une base de donnés PostgreSQL]][[fr:Créer une base de donnés PostgreSQL]]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate_fr_title=&quot;Créer une base de donnés PostgreSQL&quot;  data-link_translate_fr_url=&quot;Créer une base de donnés PostgreSQL&quot;&gt;&lt;/span&gt;[[:fr:Créer une base de donnés PostgreSQL]][[fr:Créer une base de donnés PostgreSQL]]</div></td></tr> <!-- diff cache key nl_ikwiki-ik_:diff::1.12:old-12395:rev-12396 --> </table>

Ikbot https://nl-wiki.ikoula.com/index.php?title=Een_PostgreSQL_database_maken&diff=12395&oldid=prev 2021-07-29T10:44:55Z

<p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="nl"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Oudere versie</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Versie van 29 jul 2021 10:44</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Regel 1:</td> <td colspan="2" class="diff-lineno">Regel 1:</td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;span data-link_translate_de_title=&quot;Erstellen einer PostgreSQL-Datenbank&quot;  data-link_translate_de_url=&quot;Erstellen einer PostgreSQL-Datenbank&quot;&gt;&lt;/span&gt;[[:de:Erstellen einer PostgreSQL-Datenbank]][[de:Erstellen einer PostgreSQL-Datenbank]]</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate_fr_title=&quot;Créer une base de donnés PostgreSQL&quot;  data-link_translate_fr_url=&quot;Créer une base de donnés PostgreSQL&quot;&gt;&lt;/span&gt;[[:fr:Créer une base de donnés PostgreSQL]][[fr:Créer une base de donnés PostgreSQL]]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;span data-link_translate_fr_title=&quot;Créer une base de donnés PostgreSQL&quot;  data-link_translate_fr_url=&quot;Créer une base de donnés PostgreSQL&quot;&gt;&lt;/span&gt;[[:fr:Créer une base de donnés PostgreSQL]][[fr:Créer une base de donnés PostgreSQL]]</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;br /&gt;Dit artikel is vertaald door middel van automatische vertalingssoftware. U kunt het artikel bron [[:fr:Créer une base de donnés PostgreSQL|hier]] te bekijken.&lt;br /&gt;&lt;span data-translate=&quot;fr&quot;&gt;&lt;/span&gt;&lt;br /&gt;</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;br /&gt;Dit artikel is vertaald door middel van automatische vertalingssoftware. U kunt het artikel bron [[:fr:Créer une base de donnés PostgreSQL|hier]] te bekijken.&lt;br /&gt;&lt;span data-translate=&quot;fr&quot;&gt;&lt;/span&gt;&lt;br /&gt;</div></td></tr> <!-- diff cache key nl_ikwiki-ik_:diff::1.12:old-12394:rev-12395 --> </table>

Ikbot https://nl-wiki.ikoula.com/index.php?title=Een_PostgreSQL_database_maken&diff=12394&oldid=prev 2021-07-29T10:44:00Z

<p>Nieuwe pagina aangemaakt met &#039;&lt;span data-link_translate_fr_title=&quot;Créer une base de donnés PostgreSQL&quot; data-link_translate_fr_url=&quot;Créer une base de donnés PostgreSQL&quot;&gt;&lt;/span&gt;:fr:Créer u...&#039;</p> <p><b>Nieuwe pagina</b></p><div>&lt;span data-link_translate_fr_title=&quot;Créer une base de donnés PostgreSQL&quot; data-link_translate_fr_url=&quot;Créer une base de donnés PostgreSQL&quot;&gt;&lt;/span&gt;[[:fr:Créer une base de donnés PostgreSQL]][[fr:Créer une base de donnés PostgreSQL]]<br /> &lt;br /&gt;Dit artikel is vertaald door middel van automatische vertalingssoftware. U kunt het artikel bron [[:fr:Créer une base de donnés PostgreSQL|hier]] te bekijken.&lt;br /&gt;&lt;span data-translate=&quot;fr&quot;&gt;&lt;/span&gt;&lt;br /&gt;<br /> &lt;span data-link_translate_it_title=&quot;Creare un database PostgreSQL&quot; data-link_translate_it_url=&quot;Creare un database PostgreSQL&quot;&gt;&lt;/span&gt;[[:it:Creare un database PostgreSQL]][[it:Creare un database PostgreSQL]]<br /> &lt;span data-link_translate_pt_title=&quot;Criação de uma base de dados PostgreSQL&quot; data-link_translate_pt_url=&quot;Criação de uma base de dados PostgreSQL&quot;&gt;&lt;/span&gt;[[:pt:Criação de uma base de dados PostgreSQL]][[pt:Criação de uma base de dados PostgreSQL]]<br /> &lt;span data-link_translate_es_title=&quot;Creación de una base de datos PostgreSQL&quot; data-link_translate_es_url=&quot;Creación de una base de datos PostgreSQL&quot;&gt;&lt;/span&gt;[[:es:Creación de una base de datos PostgreSQL]][[es:Creación de una base de datos PostgreSQL]]<br /> &lt;span data-link_translate_en_title=&quot;Creating a PostgreSQL database&quot; data-link_translate_en_url=&quot;Creating a PostgreSQL database&quot;&gt;&lt;/span&gt;[[:en:Creating a PostgreSQL database]][[en:Creating a PostgreSQL database]]<br /> &lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ro&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ru&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ja&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ar&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;zh&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;de&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;nl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;it&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pt&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;es&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ro&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ru&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ja&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ar&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;zh&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;de&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;nl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;it&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pt&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;es&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;en&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ro&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ru&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ja&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ar&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;zh&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;de&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;nl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;it&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pt&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;es&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;en&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ro&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ru&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ja&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ar&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;zh&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;de&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;nl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;it&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pt&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;es&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;en&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ro&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ru&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ja&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ar&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;zh&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;de&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;nl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;it&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pt&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;es&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;en&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ro&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ru&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ja&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ar&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;zh&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;de&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;nl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;it&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pt&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;es&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;en&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;he&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ro&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ru&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ja&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ar&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;zh&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;ro&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;de&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;nl&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;it&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;pt&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;es&quot;&gt;&lt;/span&gt;&lt;span data-link_translate=&quot;en&quot;&gt;&lt;/span&gt;&lt;!-- Début de l'article. Placez votre texte ci-après et n'hésitez pas à personnaliser les chapitres selon votre besoin --&gt;<br /> <br /> ==Inleiding==<br /> Dit artikel behandelt de creatie van een database en de eigenaar gebruiker.<br /> <br /> ==Verbinding maken met PostgreSQL==<br /> We gaan onder de gebruiker '''postgres''' gebruiker, dan maken we verbinding met PostgreSQL :<br /> &lt;syntaxhighlight lang=&quot;bash&quot;&gt;<br /> # su - postgres<br /> postgres@vm-postgres:~$ psql<br /> psql (9.1.24lts2)<br /> Saisissez « help » pour l aide.<br /> <br /> postgres=#<br /> &lt;/syntaxhighlight&gt;<br /> <br /> ==Aanleggen van de databank==<br /> We maken de database '''test''' :<br /> &lt;syntaxhighlight lang=&quot;bash&quot;&gt;<br /> postgres=# CREATE DATABASE test;<br /> CREATE DATABASE<br /> &lt;/syntaxhighlight&gt;<br /> <br /> Laten we eens kijken of het aangemaakt is:<br /> &lt;syntaxhighlight lang=&quot;bash&quot;&gt;<br /> postgres=# \l<br /> Liste des bases de données<br /> Nom | Propriétaire | Encodage | Collationnement | Type caract. | Droits d accès<br /> -----------+--------------+----------+-----------------+--------------+-----------------------<br /> postgres | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 |<br /> template0 | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | =c/postgres +<br /> | | | | | postgres=CTc/postgres<br /> template1 | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | =c/postgres +<br /> | | | | | postgres=CTc/postgres<br /> test | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 |<br /> (4 lignes)<br /> &lt;/syntaxhighlight&gt;<br /> <br /> Zoals we kunnen zien, is de eigenaar van de database ''test'' de gebruiker ''postgres'', we zullen dit later veranderen.<br /> <br /> ==Een gebruiker aanmaken==<br /> Nog steeds verbonden met PostgreSQL, maken we een gebruiker '''test_gebruiker''' met een wachtwoord '''wachtwoord_ikoula''' :<br /> &lt;syntaxhighlight lang=&quot;bash&quot;&gt;<br /> postgres=# CREATE USER test_user WITH PASSWORD 'password_ikoula';<br /> CREATE ROLE<br /> &lt;/syntaxhighlight&gt;<br /> <br /> ==Verandering van eigenaar van een databank==<br /> Nog steeds verbonden met PostgreSQL, veranderen we de database eigenaar '''test''' database voor onze gebruiker '''test_gebruiker''' :<br /> &lt;syntaxhighlight lang=&quot;bash&quot;&gt;<br /> postgres=# ALTER DATABASE test OWNER TO test_user;<br /> ALTER DATABASE<br /> &lt;/syntaxhighlight&gt;<br /> <br /> We controleren of de eigenaar is aangepast voor '''test_gebruiker''' :<br /> &lt;syntaxhighlight lang=&quot;bash&quot;&gt;<br /> postgres=# \l<br /> Liste des bases de données<br /> Nom | Propriétaire | Encodage | Collationnement | Type caract. | Droits d accès<br /> -----------+--------------+----------+-----------------+--------------+-----------------------<br /> postgres | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 |<br /> template0 | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | =c/postgres +<br /> | | | | | postgres=CTc/postgres<br /> template1 | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | =c/postgres +<br /> | | | | | postgres=CTc/postgres<br /> test | test_user | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 |<br /> (4 lignes)<br /> &lt;/syntaxhighlight&gt;<br /> <br /> <br /> &lt;!--T:4--&gt;<br /> &lt;!-- Fin de l'article --&gt;<br /> &lt;br /&gt;&lt;br /&gt;<br /> Cet article vous a semblé utile ? &lt;vote /&gt;<br /> <br /> &lt;!--T:5--&gt;<br /> <br /> &lt;!-- Commentaire --&gt;<br /> &lt;comments /&gt;<br /> <br /> &lt;!-- Placez ci-dessous la ou les catégories auxquelles se rapporte votre article. Ex: [[Category:Bijdragen]] [[Category:Linux]] --&gt;<br /> [[Category:PostgreSQL]] [[Category:Linux]]<br /> [[Category:VPS server]]<br /> [[Category:Dedicated server]]</div>

Ikbot