| From: | "Duncan Adams (DNS)" <duncan(dot)adams(at)vcontractor(dot)co(dot)za> |
|---|---|
| To: | postgres sql list <pgsql-sql(at)postgresql(dot)org> |
| Subject: | copy command |
| Date: | 2002-04-25 14:53:06 |
| Message-ID: | 7DD34E6DF5CD1B4283DDAB96A855DCED2F3285@vodabemail1.vodacom.co.za |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
hi all
how do you use the copy command
call me dumb, i have RTFM but i don't seem to get it.
an exstract from my dns.txt file.
aeomc04 10.121.4.157
somcmd1 10.121.23.57
aeomc05 10.121.4.162
gsmomc6 10.121.4.154
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) |
thanx
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-04-25 15:47:16 | Re: Proper quoting of \e ? |
| Previous Message | Bruce Momjian | 2002-04-25 14:43:28 | Re: Connection authentication |