Search Postgresql Archives

Re: Data loading from a flat file...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



More problems solved and created - Now I'm getting the error:

 null value in column "subject_id" violates not-null constraint

and this is nothing but column A which I talked about in the very beginning! Since its not null how can I COPY to B C and E. The same problem will arise with field E too!

AK


On 1/6/06, Angshu Kar <angshu96@xxxxxxxxx> wrote:
Thanks for the chmod command Pandu but the cat command is not doing anything!

And as Michael suggested that file has indeed carriage returns embedded in fields. I opened it in my windows m/c using textpad and got:

B1
    C1
    E1
B2
    C2
    E2
.
.
.



Any more suggestions on how to solve this? :(




On 1/6/06, Pandurangan R S <pandurangan.r.s@xxxxxxxxx> wrote:
To get rid of ^M characters you could use

cat file | tr -d ^M

you need to type ^V before you type ^M in the preceeding command. But
^V will not be displayed on the screen.

You might need to change directory permission too.

use chmod +rx <username>.

For this command to succeed you need to execute this command as root
or the owner of the directory

On 1/6/06, Angshu Kar < angshu96@xxxxxxxxx > wrote:
> Thanks Michael.
>
> I'm using PgAdmin III 1.4.0 from my WinXP m/c to access the DB in my linux
> m/c! The file has about 2GB data.It returns back to the prompt very soon.
> I'm using less or vi command to view the file and getting those ^M as
> mentioned (i.e. between fields). Any clue how I can massage the data? If you
> suggest I can try and write the script.
>
> Also, now I'm facing another permission related problem!It's throwing the
> error:
> ERROR:  could not open file "/home/akar/final.out" for reading: Permission
> denied
>  I've changed the file owner to postgres but without any avail!Also do I
> need to change the permission to akar directory? How(I'm a linux freshie)?
>
> Thanks,
> Angshu
>
>
>
> On 1/5/06, Michael Fuhr <mike@xxxxxxxx> wrote:
> > 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
> >
>
>
>
> --
> Ignore the impossible but honor it ...
> The only enviable second position is success, since failure always comes
> first...



--

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



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux