On Thu, Jan 05, 2006 at 10:51:55PM -0600, Angshu Kar wrote: > Hi Pgsql, > > I've a table schema in pg say as: > > (A B C D E) > > where none of these fields allow null. > > Now, I've a flat file that has got tab-delimited data for B,C and E fields. > And A,B come from sequences. > > Could anyone please let me know how I can upload the complete dataset into > the table?
COPY table (b, c, e) FROM file? -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
