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