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!
begin:vcard n:Chui;Raymond tel;fax:(301)713-0963 tel;home:ICQ #: 16722494 tel;work:(301)713-0624 Ext. 168 x-mozilla-html:TRUE url:http://members.xoom.com/rchui/ org:NWS, NOAA version:2.1 email;internet:[EMAIL PROTECTED] title:SA, DBA adr;quoted-printable:;;NOAA, NWS, Office of Hydrology, W/OH2=0D=0A1325 East-West Highway, Room 8112;Silver Spring;MD;20910-3283;U.S.A. x-mozilla-cpt:;30256 fn:Raymond Chui end:vcard