Re: how to use pg_dump to dump tables whose owner is me

--- On Tue, 3/3/09, Roger Chen <roger(dot)edchen(at)gmail(dot)com> wrote:

> >> Hi,
> >> Can anyone tell me how to do that? I could find
> that in man page of
> >> pg_dump. Thanks.
> >
> > pg_dump -t table1 -t table2
> >

> Thanks. If there are many tables owned by me and some other
> users, are
> there any easy ways to do that?
>

I would use psql to query all the tables you own to a file,
using a query like this:

select schemaname || '.' || tablename as to_dump
from pg_tables
where tableowner = 'myuser'

And then use xargs to or similar text tools to generate the pg_dump
command you need.