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:[EMAIL PROTECTED] > 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:[EMAIL PROTECTED]> > To: PGSQL General (E-mail) <mailto:[EMAIL PROTECTED]> > Cc: PGSQL Admin (E-mail) <mailto:[EMAIL PROTECTED]> > 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
