COPY COMMAND -- Hanging

Поиск
Список
Период
Сортировка
От Bhuvan A
Тема COPY COMMAND -- Hanging
Дата
Msg-id Pine.LNX.4.20.0110051855130.9266-100000@Larry.bks
обсуждение исходный текст
Список 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
troubleson your parents; maturity is     when you learn that everything is the fault of the younger generation.
          ======================================================================
 

Regards,
Bhuvaneswar.





В списке pgsql-sql по дате отправления:

Предыдущее
От: Morgan Curley
Дата:
Сообщение: Re: Problem with n to n relation
Следующее
От: "Mourad EL HADJ MIMOUNE"
Дата:
Сообщение: SQL-Programmer tool and field%type support