Thread

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

   Raymond Chui <raymond.chui@noaa.gov> — 2000-12-13T21:17:31Z

   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!
   

2. Re: [HACKERS] How to import/export data from/to an ASCII file?

   Thomas Lockhart <lockhart@alumni.caltech.edu> — 2000-12-14T04:34:43Z

   Use
   
     COPY table FROM 'filename' USING DELIMITERS '|';
   
                        - Thomas
   
   

3. Re: [HACKERS] How to import/export data from/to an ASCII file?

   Joel Burton <jburton@scw.org> — 2000-12-14T20:14:48Z

   > 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
   
   Look at the documentation for COPY
   
   	\h COPY
   
   Questions like this should be posted to pgsql-general, not pgsql-
   hackers.
   --
   Joel Burton, Director of Information Systems -*- jburton@scw.org
   Support Center of Washington (www.scw.org)
   
   

4. Re: How to import/export data from/to an ASCII file?

   Josh Rovero <provero@home.com> — 2000-12-15T02:54:08Z

   Try \copy or copy commands in psql:
   
   I normally use \copy for tab-delimited files.
   But copy also works and has help....
   
   \h copy
   Command:     COPY
   Description: Copies data between files and tables
   Syntax:
   COPY [ BINARY ] table [ WITH OIDS ]
        FROM { 'filename' | stdin }
        [ [USING] DELIMITERS 'delimiter' ]
        [ WITH NULL AS 'null string' ]
   COPY [ BINARY ] table [ WITH OIDS ]
        TO { 'filename' | stdout }
        [ [USING] DELIMITERS 'delimiter' ]
        [ WITH NULL AS 'null string' ]
   
   
   Raymond Chui wrote:
   
   > 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!