ALTER TABLE rental
ADD COLUMN payment_id INT;
UPDATE rental
SET payment_id=p_id
FROM (
    SELECT payment.payment_id as p_id
    FROM payment, rental
    WHERE (payment.rental_id = rental.rental_id)
) AS T