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