Re: Data loading from a flat file...

Thanks Jim. the statement is running without any error but nothing is
getting copied into the table!

Also, my data file is showing some ^M chars like

B1^M C1^M E1
B2^M C2^M E2
.
.
.

Does anyone know what can it represent?
Is it creating any trouble for the COPY command?
And can we use INSERT with COPY?

Thanks,
Angshu

On 1/5/06, Jim C. Nasby <jnasby(at)pervasive(dot)com> wrote:
>
> 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(at)pervasive(dot)com
> Pervasive Software http://pervasive.com work: 512-231-6117
> vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
>

--
Ignore the impossible but honor it ...
The only enviable second position is success, since failure always comes
first...