From: | Patrick Nelson <pnelson(at)neatech(dot)com> |
---|---|
To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Import csv |
Date: | 2002-07-26 18:02:02 |
Message-ID: | 4165C48DE9A0D211B6400800095C585F172DE5@WASHINGTON |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
terry(at)greatgulfhomes(dot)com wrote:
----------------->>>>
devtest2=# \h copy
Command: COPY
Description: copy 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' ]
Hence
COPY t1 FROM '<filename>' USING DELIMITERS ',';
----------------->>>>
Didn't even think of the psql \h copy... DOH! Feel like a tard! Anyway
thanks!
From | Date | Subject | |
---|---|---|---|
Next Message | Janning Vygen | 2002-07-26 18:09:50 | Re: plpgsql: function throws error on second call! |
Previous Message | Roderick A. Anderson | 2002-07-26 17:51:57 | Re: Advice on geolocation |