How to import/export data from/to an ASCII file? - Mailing list pgsql-hackers

From Raymond Chui
Subject How to import/export data from/to an ASCII file?
Date
Msg-id 3A37E76B.5E580785@noaa.gov
Whole thread Raw
List 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

my question!

Thank you!

Attachment

pgsql-hackers by date:

Previous
From: bpalmer
Date:
Subject: Why vacuum?
Next
From: oberpwd@anubis.network.com (Wade D. Oberpriller)
Date:
Subject: Re: [GENERAL] No postgres on Solaris