Re: importing csv files into v7.2.1 on Solaris 8 x86 - Mailing list pgsql-general

From Neil Conway
Subject Re: importing csv files into v7.2.1 on Solaris 8 x86
Date
Msg-id 20020425112916.64c377f8.nconway@klamath.dyndns.org
Whole thread Raw
In response to importing csv files into v7.2.1 on Solaris 8 x86  (Russell Aspinwall <russell.aspinwall@flomerics.co.uk>)
List pgsql-general
On Thu, 25 Apr 2002 09:13:10 +0100
"Russell Aspinwall" <russell.aspinwall@flomerics.co.uk> wrote:
> Is their a utility which will read a database table definition and
> automatically import a csv format file expecting the fields to be in the
> correct order as the table?

Yes -- take a look at COPY, and/or the psql \copy command. The syntax
is something like:

    COPY target_table FROM '/your/csv/file' USING DELIMITERS ',';

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC

pgsql-general by date:

Previous
From: David Link
Date:
Subject: Re: Why is outer Join way quicker?
Next
From: Bruce Momjian
Date:
Subject: Re: disk format changes