Re: copy - Mailing list pgsql-novice

From Christoph Della Valle
Subject Re: copy
Date
Msg-id 43E058F8.4070501@goetheanum.ch
Whole thread Raw
In response to copy  (Clifton Zama <csz@jhb.ucs.co.za>)
List pgsql-novice
hi

this is an example that worked for me
copy import  from '/data/pp.csv'    with delimiter as ',' csv quote '"';

i gues that results in:
copy tmp_table from 'supplier_merch.dat' with delimiter as '|';

maybe as can be omitted, i didn't check this.

Clifton Zama schrieb:
> Please help.
>
>  Please correct :  copy tmp_table from supplier_merch.dat with delimiter '|';
>
> ERROR:  parser: parse error at or near "table" at character 6.
>
> COPY table [ ( column [, ...] ) ]
>     FROM { 'filename' | stdin }
>     [ [ WITH ]
>           [ BINARY ]
>           [ OIDS ]
>           [ DELIMITER [ AS ] 'delimiter' ]
>           [ NULL [ AS ] 'null string' ] ]
> COPY table [ ( column [, ...] ) ]
>     TO { 'filename' | stdout }
>     [ [ WITH ]
>           [ BINARY ]
>           [ OIDS ]
>           [ DELIMITER [ AS ] 'delimiter' ]
>           [ NULL [ AS ] 'null string' ] ]
>
> .
>
> I assume table stands for table name, and all the stuff in [] is optional.
>
> I tried working this out at home, which is when I first learnt of it and
> couldn't get it to work. I had to use some psql command equivalent which I
> cannot remember correctly anymore, and cannot find in
> "/usr/local/pgsql/bin/".
>
> I don't know if it only exist in 8.0.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
>

pgsql-novice by date:

Previous
From: Christoph Della Valle
Date:
Subject: Re: How to GRANT SELECT on all tables?
Next
From: Ketema Harris
Date:
Subject: How To Return a Row or Result Set