Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28])
	by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0IK2W099629
	for <pgsql-interfaces@postgresql.org>;
	Thu, 18 Jan 2001 15:02:32 -0500 (EST)
	(envelope-from pgsql-interfaces-owner@postgresql.org)
Received: from mail1.mailshot (cyborg-group.demon.co.uk [158.152.96.100])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0IJ0X089423
	for <pgsql-interfaces@postgresql.org>;
	Thu, 18 Jan 2001 14:00:50 -0500 (EST)
	(envelope-from mike@cyborg-group.com)
Received: from [192.168.10.125] (helo=mike1.mailshot ident=root)
	by mail1.mailshot with esmtp (Exim 3.15 #1 (Debian))
	id 14JIp9-0003RL-00
	for <pgsql-interfaces@postgresql.org>; Thu, 18 Jan 2001 17:26:11 +0000
Subject: imorting csv files into postgres
From: mike <mike@cyborg-group.com>
To: pgsql-interfaces@postgresql.org
Content-Type: text/plain
X-Mailer: Evolution 0.8 (Developer Preview)
Date: 18 Jan 2001 18:03:23 +0000
Mime-Version: 1.0
Message-Id: <E14JIp9-0003RL-00@mail1.mailshot>
X-Archive-Number: 200101/203
X-Sequence-Number: 821

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