imorting csv files into postgres - Mailing list pgsql-interfaces

From mike
Subject imorting csv files into postgres
Date
Msg-id E14JIp9-0003RL-00@mail1.mailshot
Whole thread Raw
List 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



pgsql-interfaces by date:

Previous
From: Ken Wright
Date:
Subject: Re: [RFC] Proposed split of -interfaces list ...
Next
From: "Zolof"
Date:
Subject: pl/pgSQL & transaction