On Tue, 2005-04-05 at 12:10 +0530, Nageshwar Rao wrote: > Hi, > > I took a dump using the following command > > Pg_dump -f bk.dmp > > > When I tried to restore a table from the dump it just hangs there > > Pg_restore -f bk.dump -t table_name > > > Also tried by giving username also > > Any light on this. pg_restore [OPTION]... [FILE] in this case don't use -f (as that represents "output" file name) try pg_restore -d db_name -t table_name -U username bk.dmp Sven ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx