Re: dump data into complex type table

windwxc(at)sina(dot)com wrote:
> hi,everyone,first thank you help me relove the problem about complex type.
> now i have other two question about complex type field.
> firstly, i want to know if the complex type data can be dump into the database by command 'copy'?
> secondly, i try it but failure. The following is detail about my operation. my data which need be dump into data is text file and the table accepting the data is include a complex type field.
> format of text file is :
> "dd",20,"1,"010301040213","石红","红河州弥勒县虹溪镇虹溪村委会东门村小组","K236","(2005-1-1,2005-12-31)""
> "ww",2,"2,"010301010975","陈永华","红河州弥勒县虹溪镇虹溪村委会西门村小组","K236","(2005-1-1,2005-12-31)""
>

Try using tabs and omitting the double quotes.

If you still have problems, use pg_dump to dump a table containing your
complex values and examine the dump file. That'll show you how it needs
to be done.

--
Craig Ringer