RE: Importing a comma-delimited text file

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(at)home(dot)com]
Sent: Tuesday, April 11, 2000 5:37 AM
To: pgsql-questions(at)postgresql(dot)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.