webstore=> create table t1 (col1 varchar(10));

CREATE

webstore=> insert into t1 (col1) values ('test123');

INSERT 1006769 1

webstore=> select * from t1;

col1

---------

test123

(1 row)

webstore=> rollback;

NOTICE: ROLLBACK: no transaction in progress

ROLLBACK

webstore=> select * from t1;

col1

---------

test123

(1 row)