COPY COMMAND -- Hanging

From: Bhuvan A <bhuvansql(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: COPY COMMAND -- Hanging
Date: 2001-10-05 13:28:38
Message-ID: Pine.LNX.4.20.0110051855130.9266-100000@Larry.bks
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


hi all,

i am facing a strange problem in using COPY COMMAND.

As i would like to merge 2 databases, i dumped data from one by
$ pg_dump -R bhuvan -f bhuvan.sql

Here i found data dumped using COPY COMMAND.
now i tried to restore few of the tables. so i copied those tables
alone to seperate file copy_commands.sql. then, i just tried this

$ psql bhuvan -f copy_commands.sql

...

i didnt get back with the result.. even none of the records have
been copied. what could be the problem here?

======================================================================
Youth is when you blame all your troubles on your parents; maturity is
when you learn that everything is the fault of the younger generation.

======================================================================

Regards,
Bhuvaneswar.

Browse pgsql-sql by date

  From Date Subject
Next Message Mourad EL HADJ MIMOUNE 2001-10-05 13:37:14 SQL-Programmer tool and field%type support
Previous Message Bhuvan A 2001-10-05 12:59:04 COPY COMMAND -- Hanging