Query Quest PostgreSQL Course

Add records

INSERT adds new rows. Name the target columns, then supply matching values in the same order. One statement can insert several rows.

What you'll learn

RETURNING * is a PostgreSQL feature that shows the rows you just inserted.

Your mission

Add a player named 'spark' from the Forest with 400 xp.

Enable JavaScript to run SQL in the interactive lesson.