Horton

Re: [HACKERS] How to import/export data from/to an ASCII file?

Joel Burton <jburton@scw.org>

View thread
From: "Joel Burton" <jburton@scw.org>
To: Raymond Chui <raymond.chui@noaa.gov>
Cc: pgsql-general@postgresql.org
Date: 2000-12-14T20:14:48Z
Lists: pgsql-hackers 
> For example
> 
> create table testTable (
> id integer,
> name char(20)
> );
> 
> an ASCII file format with field separator "|" is
> 
> 1|Hello|
> 2|Again|
> ......
> 
> There is a way to do this in Oracle, Sybase, Informix and MySQL.
> But I want to know how to do this in PostgreSQL.
> 
> Please don't tell me use pg_dump, because it is not a correct answer
> for

Look at the documentation for COPY

	\h COPY

Questions like this should be posted to pgsql-general, not pgsql-
hackers.
--
Joel Burton, Director of Information Systems -*- jburton@scw.org
Support Center of Washington (www.scw.org)