Re: in_array: Need to specify dimensions

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster