Re: Backup of multiple tables

Andreas Joseph Krogh <andreak@officenet.no> writes:
> I usually backup my database with pg_backup without the -t option. But now I 
> need to only backup certain tables(say tab1 and tab2), is this possible with 
> pg_dump? I've tried with "pg_dump -t tab1 -t tab2" without success.

pg_dump can only handle one -t option at a time.  It'd make sense to
allow multiple -t options (likewise -n) but no one's got round to
improving the code in that particular direction.  I don't think it would
be hard; want to fix it and send in a patch?
        regards, tom lane