Re: CSV Utility - Mailing list pgsql-admin

From Steve Crawford
Subject Re: CSV Utility
Date
Msg-id 4A7B4DC0.9080509@pinpointresearch.com
Whole thread Raw
In response to CSV Utility  (Mike angelo <angelocmp@yahoo.com>)
List pgsql-admin
Mike angelo wrote:
> Is there a Postgres utility that allows data contained in a CSV file
> to be loaded into the database?
>
You mean like psql?

\copy tablename from csvfilename CSV

or with a header:
\copy tablename from csvfilename CSV HEADER

or an alternate delimiter:
\copy tablename from csvfilename CSV delimiter '|'

or export data (tab-delimited):
copy foo to stdout CSV DELIMITER E'\t';

Cheers,
Steve


pgsql-admin by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: CSV Utility
Next
From: Lennin Caro
Date:
Subject: Re: Change stored procedures schema name