Ma'lumot turlari

-h host - Server ishlayotgan host nomini belgilaydi.

8. 
   8.
   

-p port - Server ulanishlarni tinglayotgan TCP portini yoki local Unix domen socket file kengaytmasini belgilaydi.

9. 
   9.
   

-U username - Connect qilish ya'ni ulash uchun foydalanuvchi nomi.

10. 
    10.
    

-w - Hech qachon parol so'rovini bermang.

11. 
    11.
    

-W - Ma'lumotlar bazasiga ulanishdan oldin createdb'ni parol so'rashga majburlash.
cmd'ni oching. PostgresSQL o'rnatilgan papkagani o'ching va undagi Bin papkasiga kirib, ma'lumotlar bazasini yaratish uchun quyidagi buyruqni yozing,
createdb -h localhost -p 5432 -U postgres testdb
Yuqoridagini bajarganingizdan so'ng parol so'raydi va o'zingiz uchun istalgan parolni kiritib ma'lumotlar bazasini yaratishda davom eting. Yaratib bo'lganingizdan keyin uni yaratilganligini tekshirish uchun yaratilgan ma'lumotlar bazasining ro'yxatini ko'rish uchun \l buyrug'rini yozing.
Quyidagiga o'xshash natija chiqishi lozim.
postgres-# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+----------+----------+---------+-------+-----------------------
postgres | postgres | UTF8 | C | C |
template0 | postgres | UTF8 | C | C | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | C | C | =c/postgres +
| | | | | postgres=CTc/postgres
testdb | postgres | UTF8 | C | C |
(4 rows)
​
postgres-#