Обсуждение: dump data into complex type table
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)"" my table is: CREATE TABLE test2 ( address character varying(30), area1 numeric, att attritest ) WITH (OIDS=FALSE); ALTER TABLE test2 OWNER TO stuser; attritest is complex type and define is: CREATE TYPE attritest AS(ID integer, planter_no character(20).planter_name character(20),planter_address character varying(50),planter_type character(10), validtime lifetime); lifetime also complex type and includes (starttime date,endtime date) my COPY commamn is: copy test2 from 'e:\\test.txt' with DELIMITE ','; the error is: ERROR: extra data afterlase expected column. thank you! xiaochun wu
-------------------------------------------------------------------
外企高薪职位急聘( http://d1.sina.com.cn/sina/limeng3/mail_zhuiyu/2008/mail_zhuiyu_20080331.html )
-------------------------------------------------------------------
注册新浪2G免费邮箱(http://mail.sina.com.cn/)
-------------------------------------------------------------------
外企高薪职位急聘( http://d1.sina.com.cn/sina/limeng3/mail_zhuiyu/2008/mail_zhuiyu_20080331.html )
-------------------------------------------------------------------
注册新浪2G免费邮箱(http://mail.sina.com.cn/)
windwxc@sina.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 textfile 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