Re: Data loading from a flat file...

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Angshu Kar <angshu96(at)gmail(dot)com>
Cc: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Data loading from a flat file...
Date: 2006-01-06 05:48:46
Message-ID: 20060106054846.GA88946@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jan 05, 2006 at 11:04:16PM -0600, Angshu Kar wrote:
> Thanks Jim. the statement is running without any error but nothing is
> getting copied into the table!

What client are you using and what's the exact command you ran?
Does the command finish or does it never return? How much data
is there? What version of PostgreSQL are you using and on what
platform?

> Also, my data file is showing some ^M chars like
>
> B1^M C1^M E1
> B2^M C2^M E2

The ^M sequence might represent a carriage return -- how are you
viewing the file to see these characters? Are they between fields
as shown or only at the ends of lines?

> Is it creating any trouble for the COPY command?

Possibly; you might need to massage the data if you can't get COPY
to read it. That should be an easy job for a script (somebody here
can probably help).

> And can we use INSERT with COPY?

To use INSERT you'd need to read the data and generate the appropriate
INSERT commands; that's another scripting job.

--
Michael Fuhr

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Kunkel 2006-01-06 06:13:08 Re: Adding another primary key to a populated table
Previous Message Andrew - Supernews 2006-01-06 05:19:39 Re: Adding another primary key to a populated table