Re: Is it possible to import .txt files in PostgreySQL

From: "Weaver, Walt" <wweaver(at)rightnow(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Is it possible to import .txt files in PostgreySQL
Date: 2002-10-01 19:08:29
Message-ID: D408B6AC060DB24790622E1A54204DB00B1156E3@xchange.rightnowtech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Or use dos2unix...

--Walt

-----Original Message-----
From: Jeff Eckermann [mailto:jeff_eckermann(at)yahoo(dot)com]
Sent: Tuesday, October 01, 2002 1:03 PM
To: Martijn van Oosterhout; Murali Mohan Kasetty
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Is it possible to import .txt files in
PostgreySQL

--- Martijn van Oosterhout <kleptog(at)svana(dot)org> wrote:
> On Tue, Oct 01, 2002 at 05:40:42PM +0530, Murali
> Mohan Kasetty wrote:
> > Hi All,
> >
> > Is it possible to import data from .txt files
> into PostgreySQL
> > 7.1.3. If so , How do I do it?
> >
> > Any help would be greatly appreciated.
>
> \copy in psql can copy delimited files. There is a
> similar facility using
> the pq library.
>
One small point: if your .txt file originated on a
Windows machine, the lines will be terminated by
carriage return/line feed pairs. Since unix-type
operating systems only recognize the line feed as a
line terminator, the carriage return would be included
in your data. This is almost certainly not what you
want. You would need to delete those carriage returns
before importing your data. Something like:
perl -pi -e 's/\r$//' <datafile>

__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-10-01 19:19:58 Re: cluster replication with intermezzo
Previous Message Jeff Eckermann 2002-10-01 19:02:45 Re: Is it possible to import .txt files in PostgreySQL