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. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org