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

From James R. R. Service
Subject Re: Importing a comma-delimited text file
Date
Msg-id 38F51D89.120EC4DD@yahoo.com
Whole thread Raw
In response to Importing a comma-delimited text file  (Conrad Lawes <clawes@home.com>)
List pgsql-general
Conrad Lawes wrote:
>
> 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.

Try COPY.

The delimiter is "," in your case rather than the default \t.

For details see: http://alibaba.dei.uminho.pt/psql/postgres/sql-copy.htm

--
James (Jim) R.R. Service        jservice at yahoo dot com

pgsql-general by date:

Previous
From: Webb Sprague
Date:
Subject: Create Database Error
Next
From: "James R. R. Service"
Date:
Subject: Re: Search problem