Skip site navigation (1) Skip section navigation (2)

copy

From: "Duncan Adams (DNS)" <duncan(dot)adams(at)vcontractor(dot)co(dot)za>
To: pgsql-novice(at)postgresql(dot)org
Subject: copy
Date: 2002-04-25 15:00:42
Message-ID: 7DD34E6DF5CD1B4283DDAB96A855DCED2F3286@vodabemail1.vodacom.co.za (view raw or flat)
Thread:
Lists: pgsql-novice
hi all

how do you use the copy command
call me dumb, i have RTFM but i don't seem to get it.

an extract 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

P.S. sorry my last post was to the wrong group.

pgsql-novice by date

Next:From: Jerry ThompsonDate: 2002-04-25 15:20:50
Subject: Shell Script Execution
Previous:From: Klaudia WalterDate: 2002-04-25 13:39:39
Subject: Problems with \copy

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group