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 |
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 |