|
I want to add some data using Copy from command
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 [EMAIL PROTECTED] yes please foo bar blurfl furstle hammond igs xx zippy visalia harf blah always 2 y 3 1 katie pLwos5vJcMpPs [EMAIL PROTECTED] 2 n 5 2 janbuyer 4OeQbuM/xMk8E Jan Sevcik [EMAIL PROTECTED] inkchaser 415-241-9936 415-241-9938 1067 Market Street Suite 1027 San Francisco CA 94103 USA 415-241-9936 415-241-9938 Jan 5 n 9 2 kevin 32ADw9vQzhWEg 3 n 7 2 mark GuXDyWsVvZy3o Mark Courting [EMAIL PROTECTED] IBP 415-884-3566 415-884-3533 85B Galli Drive Novato CA 94946 USA 415-884-3566 415-884-3533 Receiving 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 \. |
