Re: Error while loading external data into Postgres table

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: "Bodanapu, Sravan" <Sravan(dot)Bodanapu(at)NextelPartners(dot)com>
Cc: "PGSQL General (E-mail)" <pgsql-general(at)postgresql(dot)org>, "PGSQL Admin (E-mail)" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Error while loading external data into Postgres table
Date: 2003-06-05 21:41:54
Message-ID: 1054849314.29944.164.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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(at)lucidindia(dot)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(dot)Bodanapu(at)NextelPartners(dot)com>
> To: PGSQL General (E-mail) <mailto:pgsql-general(at)postgresql(dot)org>
> Cc: PGSQL Admin (E-mail) <mailto:pgsql-admin(at)postgresql(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message kay 2003-06-05 22:07:17 Re: PG 7.1.2 Crash: cannot read xlog dir
Previous Message Vlad Efman 2003-06-05 21:38:53 unsubscribe

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-06-06 05:28:39 Re: Create index on the year of a date column
Previous Message Jan Wieck 2003-06-05 21:22:36 Re: check constraint