On Wed, Apr 14, 2010 at 11:03 AM, Scott Mead <scott.li...@enterprisedb.com>wrote:
> > On Wed, Apr 14, 2010 at 10:56 AM, akp geek <akpg...@gmail.com> wrote: > >> Dear all - >> >> Can you please help me with this? Is there a way to restore >> multiples ( more than one table ) using a single command from a whole >> database dump that was created using pg_dump >> >> I just realized what you were asking, sorry... you were asking about multiple tables during restore. I thought that you could do: pg_restore -t <table> -t <table1> or pg_restore -t <table>,<table1> But it looks like you can't (just tried it with 8.4.2 pg_restore). Sorry for the mis-read. --Scott > > Depends on exactly how you took the pg_dump. > > Did you use -F c or -F t? > > --Scott > > >> >> regards >> > >
