Perhaps you can post the first 10 lines or so of your input file and the
schema in which you are trying to import?
Robert Treat
On Mon, 2003-06-02 at 10:23, Bodanapu, Sravan wrote:
> NO. I dont have any arrays in the table.
>
> - Sravan.
>
> -----Original Message-----
> From: shreedhar [mailto:shreedhar@lucidindia.net]
> Sent: Monday, June 02, 2003 2:16 AM
> To: Bodanapu, Sravan; PGSQL General (E-mail)
> Cc: PGSQL Admin (E-mail)
> Subject: Re: [ADMIN] Error while loading external data into Postgres
> table.
>
>
>
> What is delimiter you had given in you 'Copy' command. Is there any
> array field in your destination table.
>
> Sreedhar
>
> ----- Original Message -----
>
> From: Bodanapu, Sravan <mailto:Sravan.Bodanapu@NextelPartners.com>
> To: PGSQL General (E-mail) <mailto:pgsql-general@postgresql.org>
> Cc: PGSQL Admin (E-mail) <mailto:pgsql-admin@postgresql.org>
> Sent: Monday, June 02, 2003 12:13 PM
> Subject: [ADMIN] Error while loading external data into Postgres table.
>
>
> Hi Gurus,
>
> I was trying to load data ( from flat file ) to postgres table using
> "copy" utility in postgres. It throws out an error "ERROR: copy: line 1,
> array_in: Need to specify dimension" and fails. I tried with couple of
> changes and nothing worked. Please advice me accordingly.
>
> Thanks,
>
> - Sravan.
>
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL