Doubt

From: "Sumant , The Programmer" <programmersumant(at)hotmail(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Doubt
Date: 2001-07-17 12:20:55
Message-ID: OE31HX1ygwbbslophPh0000580d@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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 myo(at)business(dot)com yes please foo bar blurfl furstle hammond igs xx zippy visalia harf blah always 2 y
3 1 katie pLwos5vJcMpPs myo(at)business(dot)com 2 n
5 2 janbuyer 4OeQbuM/xMk8E Jan Sevcik jsevcik(at)inkchaser(dot)com 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 mark(at)4ibpadpro(dot)com 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
\.

Browse pgsql-bugs by date

  From Date Subject
Next Message Denis A. Doroshenko 2001-07-17 12:30:50 Re: WIN32 Non Blocking
Previous Message Darko Prenosil 2001-07-16 22:12:48 WIN32 Non Blocking