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.


Thnx
Rao

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@postgresql.org