I want to add some data using Copy from command=20
how to do it
i have following table etc..
CREATE TABLE "buyers" (
"id" int4 DEFAULT nextval('buyers_pk_seq'::text) NOT NULL,
"fk_partnerid" int4 DEFAULT '0' NOT NULL,
"username" character varying(20) DEFAULT 'luser' NOT NULL,
"password" character varying(20),
"firstname" character varying(20) DEFAULT '' NOT NULL,
"lastname" character varying(20) DEFAULT '' NOT NULL,
"email" character varying(45) DEFAULT '' NOT NULL,
"company" character varying(45) DEFAULT '' NOT NULL,
"telephone" character varying(20) DEFAULT '' NOT NULL,
"fax" character varying(20) DEFAULT '' NOT NULL,
"address1" character varying(50) DEFAULT '' NOT NULL,
"address2" character varying(50) DEFAULT '' NOT NULL,
"city" character varying(20) DEFAULT '' NOT NULL,
"state" character(2) DEFAULT '' NOT NULL,
"zip" character varying(10) DEFAULT '' NOT NULL,
"country" character varying(20) DEFAULT '' NOT NULL,
"telephone2" character varying(20) DEFAULT '' NOT NULL,
"fax2" character varying(20) DEFAULT '' NOT NULL,
"attn" character varying(20) DEFAULT '' NOT NULL,
"bidstoshow" int4 DEFAULT '3' NOT NULL,
"blind" character DEFAULT 'n' NOT NULL,
PRIMARY KEY ("id")
);
COPY "buyers" FROM stdin;
2 1 eric bLMkTTslGPdvQ the red myo@business.com yes please foo bar blurfl f=
urstle hammond igs xx zippy visalia harf blah always 2 y
3 1 katie pLwos5vJcMpPs myo@business.com 2 n
5 2 janbuyer 4OeQbuM/xMk8E Jan Sevcik jsevcik@inkchaser.com inkchaser 415-2=
41-9936 415-241-9938 1067 Market Street Suite 1027 San Francisco CA 94103 U=
SA 415-241-9936 415-241-9938 Jan 5 n
9 2 kevin 32ADw9vQzhWEg 3 n
7 2 mark GuXDyWsVvZy3o Mark Courting mark@4ibpadpro.com IBP 415-884-3566 41=
5-884-3533 85B Galli Drive Novato CA 94946 USA 415-884-3566 415-884-3533 R=
eceiving 3 n
8 2 osborn 32854RT67hBjM 3 n
10 2 buyer 32QTbF0QqSmFM 3 n
12 1 jan 44J4u55/oLsPs 3 n
13 2 katiedemo 47CJQwZyUvOyc 3 n
\.
