Simple CRUD in Postgres

1. Open Your Terminal

   

2. write “psql -U postgres”, -U = User , postgres is user

   

3. Create Database book store

   

4. enter to database book store with “\c book_store”, in the second red box is name database that we enter

   

5. Create Table book, ‘create table book (column);’

   

6. insert data into book table

   

7. view saved data with select from book, * = all data

   

8. Update data ‘Update book Set price = 40 WHERE id =1’ , update data in table book and edit price in id 1

   

9. Delete data, but before that enter one more data

   

Note:

1. don’t copy paste because this trains your writing details from typos

2. don’t forget semicolon because it makes your command not work

3. don’t forget between dots and commas

follow me for more and more information about IT!, Thanks.