terry@greatgulfhomes.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!