Re: in_array: Need to specify dimensions

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

In response to

Browse pgsql-novice by date

  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