Re: Data loading from a flat file...

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      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461