endor's first magical adventures with PostgreSQL

"Alright, got the docker image up and running, and I'm connected to the db, both from console and from Datagrip! Cool, let's get started with the tutorial!"
*cue montage of me using Datagrip to create my first schema, then the first table, then insert a bunch of data to try things out*

"Cool, now let's see if I can view my data from the console"
db1-# select * from my_schema.table1
db1-# [nothing]

"*Ahem*, I said:"
db1-# select * from my_schema.table1
db1-# [nothing]

db1-# select * from my_schema.table1
db1-# [cricket noises]

"Wut, why can't I see the data that I inserted? Wtf is going on?"

*30 minutes later*
"Alright, I have no idea what's going on, so let's try inserting the data from console and see if Datagrip can see it"

db1-# insert into my_schema.table1(id, name, field2, field3) values (1, 'Mike', null, 123), (2, 'Jake', 0, 456);
ERROR: syntax error at or near "SELECT"
LINE 2: SELECT
^

"Wait, what?"

db1-# insert into my_schema.table1(id, name, field2, field3) values (1, 'Mike', null, 123), (2, 'Jake', 0, 456);
INSERT 0 2

"Wtf? Haaang on... "

db1-# select * from my_schema.table1;
id | name | field2 | field3
----+------+--------+--------
1 | Mike | | 123
2 | Jake | 0 | 456
1 | Mike | | 123
2 | Jake | 0 | 456
(4 rows)

*eye twitches*