Postgres 15

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table foo (id integer);
insert into foo 
select *
from generate_series(1,10);

CREATE TABLE

INSERT 0 10

begin;
truncate foo;
rollback;

BEGIN

TRUNCATE TABLE

ROLLBACK

select * from foo;

id

1

2

3

4

5

6

7

8

9

10

SELECT 10