user-interface to upload csv files

Started by Robert Buckleyover 14 years ago3 messagesgeneral
Jump to latest
#1Robert Buckley
robertdbuckley@yahoo.com

Hi,

I am having problems getting csv files into postgres. Does anyone know if there is an opensource user-interface to tackle this?

yours,

Rob

#2Craig Ringer
craig@2ndquadrant.com
In reply to: Robert Buckley (#1)
Re: user-interface to upload csv files

On 10/06/2011 01:47 PM, Robert Buckley wrote:

Hi,

I am having problems getting csv files into postgres. Does anyone know
if there is an opensource user-interface to tackle this?

If it's a well-behaved CSV file, use the COPY command or psql's \copy.

For more complicated work, use an ETL tool like Talend, look into
pg_bulkload, or write some perl/python script to do it.

--
Craig Ringer

#3Laurenz Albe
laurenz.albe@cybertec.at
In reply to: Robert Buckley (#1)
Re: user-interface to upload csv files

Robert Buckley wrote:

I am having problems getting csv files into postgres. Does anyone know if there is an opensource user-
interface to tackle this?

Did you try the COPY command (or \copy in psql)?

Yours,
Laurenz Albe