On Thu, Jan 05, 2006 at 10:51:55PM -0600, Angshu Kar wrote: > 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? See the documentation for COPY (or \copy in psql). If you need to adjust sequence values after the load you can use ALTER SEQUENCE or the setval() function. -- Michael Fuhr
