Re: import CVS file

From: Fernando Lozano <fsl(at)centroin(dot)com(dot)br>
To:
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: import CVS file
Date: 2000-09-21 01:43:17
Message-ID: 39C967B5.9E2579A0@centroin.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Peter,

> > I need to import a CVS file generated by SQL Server into PostgreSQL
>
> CSV?

Right. :-)

> > but I could not no ready utility to do this on postgresql.org. A
> > command line utility like msqlimport would be perfect, as I need to
> > use this on cron jobs. Anyone there can pelase pointe to such
> > utility?
>
> Use the COPY command.

Someone said this command only accepts TAB delimited files, with no
string delimiter. Is it possible to change these settings?

[]s, Fernando Lozano

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2000-09-21 02:02:36 Re: import CVS file
Previous Message Neil Conway 2000-09-21 01:24:17 Re: perl Pg module and result status