Re: Data loading from a flat file...
| От | Angshu Kar |
|---|---|
| Тема | Re: Data loading from a flat file... |
| Дата | |
| Msg-id | df8328740601052104od73ab36rc96b42c15ea41976@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Data loading from a flat file... ("Jim C. Nasby" <jnasby@pervasive.com>) |
| Ответы |
Re: Data loading from a flat file...
Re: Data loading from a flat file... |
| Список | pgsql-general |
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
--
Ignore the impossible but honor it ...
The only enviable second position is success, since failure always comes first...
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@pervasive.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@pervasive.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...
В списке pgsql-general по дате отправления: