Re: Importing into Postgres from a csv file - Mailing list pgsql-general

From John McKown
Subject Re: Importing into Postgres from a csv file
Date
Msg-id Pine.LNX.4.21.0008240656501.1025-100000@linux2.johnmckown.net
Whole thread Raw
In response to Importing into Postgres from a csv file  ("Jake" <ccrasoro@home.com>)
Responses Re: Importing into Postgres from a csv file  ("Roderick A. Anderson" <raanders@altoplanos.net>)
List pgsql-general
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
>
>


pgsql-general by date:

Previous
From: Janne Blomqvist
Date:
Subject: VS: JDBC
Next
From: John McKown
Date:
Subject: Re: FW: Count & Distinct