How to import/export data from/to an ASCII file?

From: Raymond Chui <raymond(dot)chui(at)noaa(dot)gov>
To: pgsql-hackers(at)postgresql(dot)org(dot)pgsql-general(at)postgresql(dot)org
Subject: How to import/export data from/to an ASCII file?
Date: 2000-12-13 21:17:31
Message-ID: 3A37E76B.5E580785@noaa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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 Content-Type Size
raymond.chui.vcf text/x-vcard 421 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martin A. Marques 2000-12-13 21:51:28 docs
Previous Message Jonathan Ellis 2000-12-13 21:03:33 Re: ERD on the cheap?

Browse pgsql-hackers by date

  From Date Subject
Next Message Martin A. Marques 2000-12-13 21:51:28 docs
Previous Message Randy Jonasz 2000-12-13 20:16:28 Re: RFC C++ Interface