Postgres - inserting multiple rows

Soldato
Joined
16 Oct 2007
Posts
7,441
Location
UK
Hi all,
Absolute beginner (day 1) here.

I've managed to insert an individual row into a new database, but how would i insert a few thousands of rows?

My syntax for individual rows:

Code:
INSERT INTO cards (id, question, answer, deck, lastupdate)
VALUES (default, 'test question', 'test answer', '8', CURRENT_TIMESTAMP)

Do I add multiple VALUES lines?

Thanks
 
Back
Top Bottom