Re: Importing a tab delimited text file - How?

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: Importing a tab delimited text file - How?
Дата
Msg-id 877jpfmzq2.fsf@asmodeus.mcnaught.org
обсуждение исходный текст
Ответ на Importing a tab delimited text file - How?  (Ken Tozier <kentozier@comcast.net>)
Ответы Re: Importing a tab delimited text file - How?  (Ken Tozier <kentozier@comcast.net>)
Список pgsql-general
Ken Tozier <kentozier@comcast.net> writes:

> I've been looking though the PostgreSQL documentation but can't seem
> to find a command for importing files. I read the documentation
> related to large objects but this isn't what I'm looking for as I
> don't want to import the entire file into a single field, I want to
> import it as a table. I'm sure there's a way to do it but I can't seem
> to find the magic command.
>
> Could someone point me to (or provide) an example?

You want the SQL COPY statement, or the \copy command in 'psql'.

-Doug

В списке pgsql-general по дате отправления:

Предыдущее
От: Robby Russell
Дата:
Сообщение: Re: Importing a tab delimited text file - How?
Следующее
От: Karim Nassar
Дата:
Сообщение: Re: Duplicating a database