www.postgres.uz Open in urlscan Pro
172.67.134.197  Public Scan

Form analysis
2 forms found in the DOM

<form class="md-header__option" data-md-component="palette">
  <input class="md-option" data-md-color-media="" data-md-color-scheme="default" data-md-color-primary="teal" data-md-color-accent="purple" aria-label="Switch to dark mode" type="radio" name="__palette" id="__palette_0">
  <label class="md-header__button md-icon" title="Switch to dark mode" for="__palette_1">
    <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
      <path d="M17 6H7c-3.31 0-6 2.69-6 6s2.69 6 6 6h10c3.31 0 6-2.69 6-6s-2.69-6-6-6zm0 10H7c-2.21 0-4-1.79-4-4s1.79-4 4-4h10c2.21 0 4 1.79 4 4s-1.79 4-4 4zM7 9c-1.66 0-3 1.34-3 3s1.34 3 3 3 3-1.34 3-3-1.34-3-3-3z"></path>
    </svg>
  </label>
  <input class="md-option" data-md-color-media="" data-md-color-scheme="slate" data-md-color-primary="teal" data-md-color-accent="lime" aria-label="Switch to light mode" type="radio" name="__palette" id="__palette_1">
  <label class="md-header__button md-icon" title="Switch to light mode" for="__palette_0" hidden="">
    <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
      <path d="M17 7H7a5 5 0 0 0-5 5 5 5 0 0 0 5 5h10a5 5 0 0 0 5-5 5 5 0 0 0-5-5m0 8a3 3 0 0 1-3-3 3 3 0 0 1 3-3 3 3 0 0 1 3 3 3 3 0 0 1-3 3Z"></path>
    </svg>
  </label>
</form>

Name: search —

<form class="md-search__form" name="search">
  <input type="text" class="md-search__input" name="query" aria-label="Qidirish" placeholder="Qidirish" autocapitalize="off" autocorrect="off" autocomplete="off" spellcheck="false" data-md-component="search-query" required="">
  <label class="md-search__icon md-icon" for="__search">
    <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
      <path d="M9.5 3A6.5 6.5 0 0 1 16 9.5c0 1.61-.59 3.09-1.56 4.23l.27.27h.79l5 5-1.5 1.5-5-5v-.79l-.27-.27A6.516 6.516 0 0 1 9.5 16 6.5 6.5 0 0 1 3 9.5 6.5 6.5 0 0 1 9.5 3m0 2C7 5 5 7 5 9.5S7 14 9.5 14 14 12 14 9.5 12 5 9.5 5Z"></path>
    </svg>
    <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
      <path d="M20 11v2H8l5.5 5.5-1.42 1.42L4.16 12l7.92-7.92L13.5 5.5 8 11h12Z"></path>
    </svg>
  </label>
  <nav class="md-search__options" aria-label="Qidirish">
    <button type="reset" class="md-search__icon md-icon" title="Tozalash" aria-label="Tozalash" tabindex="-1">
      <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
        <path d="M19 6.41 17.59 5 12 10.59 6.41 5 5 6.41 10.59 12 5 17.59 6.41 19 12 13.41 17.59 19 19 17.59 13.41 12 19 6.41Z"></path>
      </svg>
    </button>
  </nav>
  <div class="md-search__suggest" data-md-component="search-suggest"></div>
</form>

Text Content

Tarkibga o'tish

PostgreSQL
Bosh sahifa

Qidiruvni boshlash uchun kiriting
PostgreSQL
 * Bosh sahifa
 * Boshlang'ich
   Boshlang'ich
    * #0. Ma'lumotlar ombori nima?
    * #1. PostgreSQLga kirish
    * #2. Linuxga o'rnatish
    * #3. Windowsga o'rnatish
    * #4. Macga o'rnatish
    * #5. Ma'lumotlar bazasi yaratish
    * #6. Jadvallar bilan ishlash
    * #7. Asosiy so'rovlar




POSTGRESQL DARSLARIGA XUSH KELIBSIZ!

PostgreSQL - bu relyatsion ma'lumotlar omborini boshqarish tizimi. Ya'ni,
ma'lumotlarni boshqarish tizimi bo'lib, u aloqalar(relation) ko'rinishida taqdim
etiladi. Aloqa - jadvallarni matemetik aniq ifodalash. Ma'lumotlarni jadvallarda
saqlash hozirgi vaqtda shunchalik tarqalganki, huddi bu ma'lumotlarni saqlashni
eng tabiiy yo'li hisoblanadigandek. Lekin ma'lumotlarni saqlashni turli xil
boshqa yo'llari mavjud. Masalan, Unix oilasiga kirivchi operatsion tizimlarda
fayllar va kataloglar iyerarxik ko'rinishdagi ma'lumotlar ombori. Bundan
tashqari hozirgi kunda, opyektga yo'naltirilgan ma'lumotlar ombori juda tez
rivojlanmoqda.

Har qanday jadval, nomlangan qatorlardan tashkil topadi. Jadvaldagi hamma
qatorlar bir xil nomlangan ustinlardan tashkil topadi. Bu holatda har bitta
ustun uchun qandaydir bir tipni ko'rsatish mumkin. Ya'ni bu ustunga tegishli
ma'lumotlar qaysi tipda bo'lishi mumkinligini aniqlab olish. Ustunlar tartibi
hamma qatorlarda aniq o'zgarmas bo'lada, SQL jadvalda aniq bir tartibni saqlab
bermaydi, lekin uni so'rov vaqtida tartiblash mumkin bo'ladi.

Jadvallar ma'lumotlar omboriga birlashtiriladi, aniq bir PostgreSQL serverdagi
ma'lumotlar ombori esa ma'lumotlar ombori klasteri tashkil etadi.

Made with Material for MkDocs