Re: import CVS file - Mailing list pgsql-general

From Fernando Lozano
Subject Re: import CVS file
Date
Msg-id 39C967B5.9E2579A0@centroin.com.br
Whole thread Raw
In response to Re: import CVS file  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: import CVS file  (Neil Conway <nconway@klamath.dyndns.org>)
List 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



pgsql-general by date:

Previous
From: Danny
Date:
Subject: data type (datetime)
Next
From: Neil Conway
Date:
Subject: Re: import CVS file