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
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 |
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 |