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.157
somcmd1 | 10.121.23.57
aeomc05 | 10.121.4.162
gsmomc6 | 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) |
>