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

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Raymond Chui <raymond(dot)chui(at)noaa(dot)gov>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [HACKERS] How to import/export data from/to an ASCII file?
Date: 2000-12-14 04:34:43
Message-ID: 3A384DE3.C6DBBD92@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Use

COPY table FROM 'filename' USING DELIMITERS '|';

- Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sandeep Joshi 2000-12-14 05:04:02 trigger
Previous Message Robert B. Easter 2000-12-14 04:32:00 Re: Re: Daily Digest V1 #108

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2000-12-14 05:02:26 Re: pg_options.sample
Previous Message Bruce Momjian 2000-12-14 04:17:08 Re: Bug in FOREIGN KEY