Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group