Re: [GENERAL] FW: How to upload data to postgres

2008-09-10 Thread Markova, Nina
Adrian, The trick seems to work. Thanks! Nina -Original Message- From: Adrian Klaver [mailto:[EMAIL PROTECTED] Sent: September 10, 2008 11:58 To: Markova, Nina Cc: pgsql-general@postgresql.org; [EMAIL PROTECTED] Subject: RE: [GENERAL] FW: How to upload data to postgres

Re: [GENERAL] FW: How to upload data to postgres

2008-09-10 Thread Adrian Klaver
--- Original message -- From: "Markova, Nina" <[EMAIL PROTECTED]> > > I also plan to try to export data in XML format (from Ingres) and import > it to Postgres. > > I didn't find any utility for importing XML data into Postgres. Or just > looking at the wrong documen

Re: [GENERAL] FW: How to upload data to postgres

2008-09-10 Thread Markova, Nina
EMAIL PROTECTED] Sent: September 10, 2008 10:39 To: pgsql-general@postgresql.org Cc: Markova, Nina; [EMAIL PROTECTED] Subject: Re: [GENERAL] FW: How to upload data to postgres On Wednesday 10 September 2008 7:14:50 am Markova, Nina wrote: > Thanks Adrian. > > I have read the Postgres 'cop

Re: [GENERAL] FW: How to upload data to postgres

2008-09-10 Thread Adrian Klaver
On Wednesday 10 September 2008 7:14:50 am Markova, Nina wrote: > Thanks Adrian. > > I have read the Postgres 'copy' - the problem is that Postgres doesn't > understand Ingres format. This is I think where the failure comes from. > If I don't find a tool, I have to write scripts to convert data to >

Re: [GENERAL] FW: How to upload data to postgres

2008-09-10 Thread Markova, Nina
va, Nina Subject: Re: [GENERAL] FW: How to upload data to postgres On Tuesday 09 September 2008 1:54:12 pm Markova, Nina wrote: > So far I tried; > > 1) I have copied data from Ingres in ASCII (using Ingres copydb > command). > 2) created a table in a Postgres database > 3) t

Re: [GENERAL] FW: How to upload data to postgres

2008-09-09 Thread Adrian Klaver
On Tuesday 09 September 2008 1:54:12 pm Markova, Nina wrote: > So far I tried; > > 1) I have copied data from Ingres in ASCII (using Ingres copydb > command). > 2) created a table in a Postgres database > 3) tried loading data into Potgres table - encounter problems. > > For 1) (the Ingres part