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

Exits PostgreSQL completely and returns to the Linux terminal.

\q

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;

SELECT * FROM bookings;

SELECT * FROM bookings LIMIT 10;

SELECT *
FROM bookings
WHERE status = 'confirmed';

INSERT INTO bookings
(user_id, status)
VALUES
(10, 'pending'),
(11, 'confirmed'),
(12, 'cancelled');

UPDATE bookings
SET status = 'confirmed'
WHERE id = 10;

UPDATE bookings
SET
    status = 'confirmed',
    updated_at = NOW()
WHERE id = 10;

DELETE FROM bookings
WHERE id = 10;


DELETE FROM bookings
WHERE id = 10
RETURNING *;

To see all fields/columns of a particular PostgreSQL table, use:

## \d bookings

DELETE FROM users
WHERE kc_user_id IS NULL
   OR kc_user_id NOT IN (
       '6b4bc082-3329-4973-8493-d70cdc2eab4a',
       '0c2c40d7-cf4e-4868-bb50-0425267035fd',
       'a2132c98-b754-4d30-9ec1-18f43ecd5041',
       'bd15ebc7-3e38-418a-a496-f6bfe5dc42d0'
   );

DELETE FROM organizer_profiles
WHERE kc_user_id IS NULL
   OR kc_user_id NOT IN (
       '6b4bc082-3329-4973-8493-d70cdc2eab4a',
       '0c2c40d7-cf4e-4868-bb50-0425267035fd',
       'a2132c98-b754-4d30-9ec1-18f43ecd5041',
       'bd15ebc7-3e38-418a-a496-f6bfe5dc42d0'
   );

SELECT * FROM users;

Debug School

How to delete particular row from postgress pgsql using commands

Top comments (0)