SELECT returns empty resultset

Question

When I try to insert and select data from a table, I get an empty result set. I do it like this:

reestr-# INSERT INTO datatype(code) VALUES ('blabla')
reestr-# SELECT * FROM datatype
reestr-#

So, I get no errors or warnings in the console, but still I'm unable to insert or select any data. By the way, I even tried to insert into an invalid field cod instead of code and got no errors - this is really strange.

Answer 1

end your query with a ; => SELECT * FROM datatype;