RE: Importing a comma-delimited text file - Mailing list pgsql-general

From Culberson, Philip
Subject RE: Importing a comma-delimited text file
Date
Msg-id A95EFC3B707BD311986C00A0C9E95B6A9DE640@datmail03.dat.com
Whole thread Raw
In response to Importing a comma-delimited text file  (Conrad Lawes <clawes@home.com>)
List pgsql-general
With your Postgres distribution should have come a number of PDF files.
These are a far better source of information than the \h of psql.  They can
be found in the /doc directory of the distribution tree.  For your question,
look in the user.pdf file.

Briefly, the command would look like:

COPY table_name FROM '/foo/bar/myfile.txt' USING DELIMITERS ',';

Phil Culberson
DAT Services

-----Original Message-----
From: Conrad Lawes [mailto:clawes@home.com]
Sent: Tuesday, April 11, 2000 5:37 AM
To: pgsql-questions@postgresql.org
Subject: [GENERAL] Importing a comma-delimited text file


What is the command to import data into a table from comma-delimited
text file?
Unfortunately, the psql on-line help (\h) does not provide a clear
explanation.

Thanks.

pgsql-general by date:

Previous
From: "Culberson, Philip"
Date:
Subject: RE: JDBC connection - DB Prep?
Next
From: "news1.on.sympatico.ca"
Date:
Subject: SQL query question