On Thu, Jan 05, 2006 at 22:51:55 -0600, Angshu Kar <angshu96@xxxxxxxxx> 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? Use COPY or INSERT with explicitly named columns. (I think this is a relatively new feature for COPY, but you can use it for INSERT in any version.)
