imorting csv files into postgres

From: mike <mike(at)cyborg-group(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: imorting csv files into postgres
Date: 2001-01-18 18:03:23
Message-ID: E14JIp9-0003RL-00@mail1.mailshot
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Does anyone know if you can import csv text files into postgres

I have tried the COPY command and it needs to have an existing table,
while what I want to do is create a new table from a csv file.

Also is there any way to define the text seperater ala MSSQL eg
field seperator = ,
text seperator = "

Thanks

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Craig Brozefsky 2001-01-18 18:24:16 Re: some libpq interface issues
Previous Message Peter T Mount 2001-01-18 17:44:08 JDBC: New updates to CVS