| 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: | Whole Thread | Raw Message | 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 |