Re: [HACKERS] How to import/export data from/to an ASCII file? - Mailing list pgsql-general

From Joel Burton
Subject Re: [HACKERS] How to import/export data from/to an ASCII file?
Date
Msg-id 3A38E3E8.21120.D709E2@localhost
Whole thread Raw
In response to How to import/export data from/to an ASCII file?  (Raymond Chui <raymond.chui@noaa.gov>)
List pgsql-general
> 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)

pgsql-general by date:

Previous
From: "Joel Burton"
Date:
Subject: Re: RI and restoring dumps
Next
From: npat@kmp.forthnet.gr
Date:
Subject: is libpq thread-safe?