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: | Raw Message | Whole Thread | 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 |