create table a(i int); insert into a values (1); create table a1() inherits(a); insert into a1 values (1); -- Only the parent table is copied, as the documentation claims. copy a to stdout; alter table a enable row level security; create role u; create policy pol_perm on a as permissive for select to u using (true); grant select on table a to u; set role u; -- Both "a" and "a1" appears in the output. copy a to stdout;