Francisco Reyes <lists@xxxxxxxxxxxxxxxx> writes: > I however noticed that pg_dump also does this: > ALTER TABLE public.mytable OWNER TO pgsql; > Shouldn't the "public." be left out? Probably in an ideal world, but that code is far from ideal --- it's dealing with a bunch of considerations including compatibility with dump files from old pg_dump versions with assorted bugs. I'm hesitant to remove the schema spec for fear we'd end up with underspecified output in some corner case or other. regards, tom lane
