Re: Using COPY to import large xml file - Mailing list pgsql-general

From Christoph Moench-Tegeder
Subject Re: Using COPY to import large xml file
Date
Msg-id 20180625061044.2rxxpvlon7qxalbi@squirrel.exwg.net
Whole thread Raw
In response to Re: Using COPY to import large xml file  (Anto Aravinth <anto.aravinth.cse@gmail.com>)
List 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 by date:

Previous
From: Tim Cross
Date:
Subject: Re: Using COPY to import large xml file
Next
From: Akshaya Acharya
Date:
Subject: Too many range table entries error