Re: Using COPY to import large xml file

From: Christoph Moench-Tegeder <cmt(at)burggraben(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Using COPY to import large xml file
Date: 2018-06-25 06:10:45
Message-ID: 20180625061044.2rxxpvlon7qxalbi@squirrel.exwg.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

## Anto Aravinth (anto(dot)aravinth(dot)cse(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Akshaya Acharya 2018-06-25 07:32:37 Too many range table entries error
Previous Message Tim Cross 2018-06-25 02:39:16 Re: Using COPY to import large xml file