From: | John Taylor <postgres(at)jtresponse(dot)co(dot)uk> |
---|---|
To: | Wei Wang <chumanlu(at)yahoo(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: in_array: Need to specify dimensions |
Date: | 2002-06-19 08:18:41 |
Message-ID: | 02061909184100.01538@splash.hq.jtresponse.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Wednesday 19 June 2002 03:15, Wei Wang wrote:
> Hi, all
>
> I am trying to use COPY <table> FROM <ascii file>
> to put my backup data into my table. However, the copy
> command fails and the error message is:
> in_array: Need to specify dimensions
>
> Does any one know what causes this kind of errors?
> Thanks a lot!
>
Without seeing a line from your data file, I cannot be sure, but I expect that you
are putting quotes in your data file.
You may have something like:
'some text'\t'{"value1","value2","value3"}'
You need something like:
some text\t{"value1","value2","value3"}
To be sure of the correct format of the data file you can create some records in the table,
and then COPY <table> TO <ascii file>
Regards
JohnT
From | Date | Subject | |
---|---|---|---|
Next Message | John Taylor | 2002-06-19 08:24:56 | Re: Which indexes to drop |
Previous Message | Joseph.ROTHWELL | 2002-06-19 06:47:19 | unsubsribe NOVICE |