| 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: | Whole Thread | Raw Message | 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 | 
| 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? | 
| 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 |