Re: Importing into Postgres from a csv file

From: Jerome Raupach <jraupach(at)intelcom(dot)fr>
To: John McKown <jmckown(at)prodigy(dot)net>, Jake <ccrasoro(at)home(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Importing into Postgres from a csv file
Date: 2000-08-24 12:41:04
Message-ID: 39A517E0.45B7ABA9@intelcom.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

John McKown wrote:
>
> I think that you can do this using the COPY verb in psql.
>
> COPY table FROM file USING DELIMITERS ',';
>
> Just be sure that the order of the data in the file is the same as the
> order of the variables in the table.
>
> John
>
> On Wed, 23 Aug 2000, Jake wrote:
> > Does any one know if this is possible, and if so how?
> >
> >
> > Jake
> >
> >

COPY table FROM '/usr/file' USING DELIMITERS ',';

with the complete path.
Jerome.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message jeff seaman 2000-08-24 12:55:47 Postgresql on Solaris 8
Previous Message John McKown 2000-08-24 11:58:58 Re: Importing into Postgres from a csv file