I'd put them all into the same schema and dump that. pg_dump -n schemaname On Tue, Mar 3, 2009 at 8:30 AM, Roger Chen <roger.edchen@xxxxxxxxx> wrote: > Thanks. If there are many tables owned by me and some other users, are > there any easy ways to do that? > > On Mon, Mar 2, 2009 at 9:23 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: >> On Mon, Mar 2, 2009 at 5:31 PM, Roger Chen <roger.edchen@xxxxxxxxx> 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 >> >> ? >> > -- When fascism comes to America, it will be the intolerant selling it as diversity. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general