Re: copy command

Hello!
You only need to put an "\" in front of "copy". It is an internal command. And you don't need ";" at the end

it would be:
bpsimple=# \copy dns_ip from 'dns.txt'
\.
bpsimple=# SELECT * FROM dns_ip;  dns   |      ip     
---------+---------------aeomc04 | 10.121.4.157somcmd1 | 10.121.23.57aeomc05 | 10.121.4.162gsmomc6 | 10.121.4.154
(4 rows)

\.  is the response and tells you that it worked.
I actually tried it with "\copy dns_ip from dns.txt", without the 
quotes and it also worked perfectly.

Svilen Dyakovski

On 25 Apr 02, at 16:53, Duncan Adams  (DNS) wrote:

> 
> wire_dev=> copy dns_ip from dns.txt
> wire_dev-> ;
> ERROR:  parser: parse error at or near "dns"
> wire_dev=> copy dns_ip from /database/pgsql/dns.txt
> wire_dev-> ;
> ERROR:  parser: parse error at or near "/"
> wire_dev=>
> wire_dev=> \d dns_ip
>                 Table "dns_ip"
>  Attribute |         Type          | Modifier
> -----------+-----------------------+----------
>  dns       | character varying(32) |
>  ip        | character varying(32) |
>