Cmd commands for postgresql

cmd commands for postgresql.
\l - databaselarni chiqaradi

\d - database tablelarini chiqaradi

\d table_nomi - table dagi detallar royxati
drop table table_nomi; - tableni uchiradi

drop database database_nomi; - bazani uchiradi bunda boshqa bazaga o'tib keyin buyruq yoziladi

table-jadvalga ma'lumot kiritish.

INSERT INTO table_name (column_name1, column_name2, column_name3.. ) VALUES ('value1', 'value2', 'value3'...);

M:

INSERT INTO my_contacts (first_name) VALUES ('Shohijahon');

INSERT INTO my_contacts VALUES ('Shohijahon', 'Yodgorov', '1990-05-05', 'doctor', 'cars'); - bunda hammasiga tartib bilan value kiritish kk