Is it possible to import .txt files in PostgreySQL

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.

--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

--- Martijn van Oosterhout <kleptog@svana.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

Or use dos2unix...

--Walt

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

--- Martijn van Oosterhout <kleptog@svana.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@postgresql.org)