[EMAIL PROTECTED] 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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
