Re: Importing into Postgres from a csv file

From: John McKown <jmckown(at)prodigy(dot)net>
To: Jake <ccrasoro(at)home(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Importing into Postgres from a csv file
Date: 2000-08-24 11:58:58
Message-ID: Pine.LNX.4.21.0008240656501.1025-100000@linux2.johnmckown.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jerome Raupach 2000-08-24 12:41:04 Re: Importing into Postgres from a csv file
Previous Message John McKown 2000-08-24 11:55:47 Re: FW: Count & Distinct