Re: Error while loading external data into Postgres table
От | Robert Treat |
---|---|
Тема | Re: Error while loading external data into Postgres table |
Дата | |
Msg-id | 1054849314.29944.164.camel@camel обсуждение исходный текст |
Ответ на | Re: Error while loading external data into Postgres table ("Bodanapu, Sravan" <Sravan.Bodanapu@NextelPartners.com>) |
Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: