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

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 (view raw or flat)
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
\.

pgsql-bugs by date

Next:From: Denis A. DoroshenkoDate: 2001-07-17 12:30:50
Subject: Re: WIN32 Non Blocking
Previous:From: Darko PrenosilDate: 2001-07-16 22:12:48
Subject: WIN32 Non Blocking

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