Re: Using COPY to import large xml file

Поиск
Список
Период
Сортировка
От Christoph Moench-Tegeder
Тема Re: Using COPY to import large xml file
Дата
Msg-id 20180625061044.2rxxpvlon7qxalbi@squirrel.exwg.net
обсуждение исходный текст
Ответ на Re: Using COPY to import large xml file  (Anto Aravinth <anto.aravinth.cse@gmail.com>)
Список pgsql-general
## Anto Aravinth (anto.aravinth.cse@gmail.com):

> Sure, let me try that.. I have a question here, COPY usually works when you
> move data from files to your postgres instance, right? Now in node.js,
> processing the whole file, can I use COPY
> programmatically like COPY Stackoverflow <calculated value at run time>?
> Because from doc:
> 
> https://www.postgresql.org/docs/9.2/static/sql-copy.html
> 
> I don't see its possible. May be I need to convert the files to copy
> understandable first?

"COPY ... FROM STDIN"
 STDIN Specifies that input comes from the client application.

It's on the page...

Regards,
Christoph

-- 
Spare Space.


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

Предыдущее
От: Tim Cross
Дата:
Сообщение: Re: Using COPY to import large xml file
Следующее
От: Akshaya Acharya
Дата:
Сообщение: Too many range table entries error