From: ARP <arnaud.mlist1@free.fr>
To: Duncan Adams (DNS) <duncan.adams@vcontractor.co.za>
To: postgres sql list <pgsql-sql@postgresql.org>
Subject: Re: copy command
Date: Thu, 25 Apr 2002 20:34:09 +0200
Message-ID: <008401c1ec87$ced6ac80$0100a8c0@arp.homelinux.org> (raw)
References: <7DD34E6DF5CD1B4283DDAB96A855DCED2F3285@vodabemail1.vodacom.co.za>
I think you need the quote around the file name since it's not a keyword and it's text.
Then your dns.txt file needs to be formated correctly, especially concerning the separator : by default I think TABs are used and \N is used to say NULL. You can go aver that with USING DELIMITERS ';' for example and WITH NULL AS '' if your dns.txt look like this :
aeomc04;10.121.4.157
somcmd1;10.121.23.57
aeomc05;10.121.4.162
gsmomc6;10.121.4.154
hope this helps
Arnaud
----- Original Message -----
From: "Duncan Adams (DNS)" <duncan.adams@vcontractor.co.za>
To: "postgres sql list" <pgsql-sql@postgresql.org>
Sent: Thursday, April 25, 2002 4:53 PM
Subject: [SQL] copy command
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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: arnaud.mlist1@free.fr, duncan.adams@vcontractor.co.za
Subject: Re: copy command
In-Reply-To: <008401c1ec87$ced6ac80$0100a8c0@arp.homelinux.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox