Re: Error while loading external data into Postgres table

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