Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
> I just inserted the ALTER OWNER statement between the CREATE and the
> GRANTs. Why do you want them at the end of the dump?
So that the initial owner is still owner when he does COPY, ALTER TABLE
ADD PRIMARY KEY, etc etc. Else you're gonna have problems.
The regression database is next to useless as a testbed for this,
btw, since all the objects in it are owned by the superuser anyway.
regards, tom lane