Re: Load Text File into DB

Поиск
Список
Период
Сортировка
От Chris Jones
Тема Re: Load Text File into DB
Дата
Msg-id 9b7gee$2b5o$1@news.tht.net
обсуждение исходный текст
Ответ на Load Text File into DB  ("Karl J. Stubsjoen" <karlflips@kstub.com>)
Список pgsql-general
This is what I have used with success..

copy {table name} from '{delimited file name}' using delimiters '\t' with
null as '';

Of course, don't put in the brackets and you can use whatever null character
you might need...

Hope this helps

Chris
Karl J. Stubsjoen wrote in message <9b20s1$1b3d$1@news.tht.net>...
>Hello,
>
>I have a tab delimited text file located on the server and would like to
>load this into a table.  How do I accomplish this?
>
>Thanks!
>
>Karl
>
>



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

Предыдущее
От: Justin Clift
Дата:
Сообщение: Benchmarking PostgreSQL
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Got stumped.. Need assistance with a sql query