How to delete particular row from postgress pgsql using commands

Enter PostgreSQL
Show all databases
Connect to a particular database
delete all rows from table

Enter PostgreSQL

sudo -u postgres psql

Show all databases

Inside psql:

\l

or:

\list

Example:

hl_booking
hl_country
hl_profile
hl_trip
postgres

Connect to a particular database

For example:

\c hl_booking

You should see:

You are now connected to database "hl_booking".

Then show all tables:

\dt

Suppose your table name is bookings.

delete all rows from table

To delete all rows but keep the table structure:

DELETE FROM availability_slots;