Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Problem with \copy

From: Thomas Good <tomg(at)admin(dot)nrnet(dot)org>
To: Marc Eggenberger <me(at)ieo(dot)ch>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Problem with \copy
Date: 1998-12-29 02:40:43
Message-ID: Pine.LNX.3.96.981228212601.25399A-100000@admin.nrnet.org (view raw or flat)
Thread:
Lists: pgsql-general
On Mon, 28 Dec 1998, Marc Eggenberger wrote:

> Hi there.
> 
> I have some problems with importing a large txt db into postgres ... I try to use the \copy db from xyz to import from a tabulator spaced textfile ... it takes 2-3sec then a "broken pipe" comes up and psql is beeing left ....
> anyone knows if there's a possibility to turn on something like "debugging mode" so that I get more infos than just "broken pipe"?

Hallo Marc,

Is it possible you could have any ctrl chars in your data?
Any *apostrophes* that aren't escaped?

This may be completely off track but I've wasted god knows how much time
looking for other problems when I had forgotten to escape single quotes...

I use the following to `fix' user input when I get single quotes in char
strings: $usr_input =~ s/\'/s/\\'/g;  If this is the problem you could use
sed to escape any single quotes in your dump file...HTH!

Viel erfolg,
Tom

> --
> mit freundlichen Gruessen
> =====================================
> Inside Electronic Online   www.ieo.ch
> Eggenberger Marc            me(at)ieo(dot)ch
> Leimbachstr. 56        Tel 01/4802800
> 8041 Zuerich            Fax 01/4802801
> =====================================
> 


    ---------- Sisters of Charity Medical Center ----------
                   Department of Psychiatry
                            ----     
    Thomas Good                          <tomg(at)q8(dot)nrnet(dot)org>
    Coordinator, North Richmond C.M.H.C. Information Systems
    75 Vanderbilt Ave, Quarters 8        Phone: 718-354-5528
    Staten Island, NY   10304            Fax:   718-354-5056


In response to

pgsql-general by date

Next:From: Robert ChalmersDate: 1998-12-29 02:59:56
Subject: Is there a script for cleanly shutting down
Previous:From: Carl RichesDate: 1998-12-29 01:05:50
Subject: Re: [GENERAL] Release of 6.4.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group