RE: Importing a comma-delimited text file

Поиск
Список
Период
Сортировка
От Culberson, Philip
Тема RE: Importing a comma-delimited text file
Дата
Msg-id A95EFC3B707BD311986C00A0C9E95B6A9DE640@datmail03.dat.com
обсуждение исходный текст
Ответ на Importing a comma-delimited text file  (Conrad Lawes <clawes@home.com>)
Список 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 по дате отправления:

Предыдущее
От: "Culberson, Philip"
Дата:
Сообщение: RE: JDBC connection - DB Prep?
Следующее
От: "news1.on.sympatico.ca"
Дата:
Сообщение: SQL query question