Subject: Re: Bulk_insert in postgresql like Microsoft SQL server
To: pgsql-admin@lists.postgresql.org
Newsgroups: gmane.comp.db.postgresql.admin
References: 
 <CAE+tJY9xX=Yu50dD45xCz5auKVAgBv_hZrdGK_5koQkzW9jj-g@mail.gmail.com>
 <CAKFQuwYjJ2svQ7hFbtJXY5+KC=wD3hqyfpeD5qLvyq=U8XaRjg@mail.gmail.com>
 <CAE+tJY9JaLKt4XsXSS02qfGa2vOB6-rmN2dE=95jM4NYcW4KLQ@mail.gmail.com>
From: Thomas Kellerer <spam_eater@gmx.net>
Message-ID: <f3c0a73a-ddce-010d-9088-4dee82ff711b@gmx.net>
Date: Thu, 20 Dec 2018 14:25:49 +0100
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23)
 Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666
MIME-Version: 1.0
In-Reply-To: 
 <CAE+tJY9JaLKt4XsXSS02qfGa2vOB6-rmN2dE=95jM4NYcW4KLQ@mail.gmail.com>
Content-Type: text/plain; charset=utf-8
Content-Language: de-DE
Content-Transfer-Encoding: 8bit
Precedence: bulk

Devendra Yadav schrieb am 19.12.2018 um 18:58:
>>     On Wed, Dec 19, 2018 at 10:29 AM Devendra Yadav <devendra.857@gmail.com <mailto:devendra.857@gmail.com>> wrote:
>>     > But the case is that, for it to happen it needs superuser permission which
>> 
>>     It only requires superuser permission if you ask the server to COPY a
>>     file from the local filesystem.  Developers and programs should be
>>     using client libraries and feeding the data to be copied (in or out)
>>     to the server via the connection (which, for the server, is a
>>     stdin/stdout stream).  psql provides this via \copy - other libraries
>>     have their own methods.

> Thanks for the information David. I'll check that. We have most of
> our applications in Java and .net, if you can please highlight on
> these ?
With JDBC you can use the CopyManager API together with a "COPY FROM STDIN" statement.

https://jdbc.postgresql.org/documentation/publicapi/org/postgresql/copy/CopyManager.html

There are some examples on Stackoverflow:

  https://stackoverflow.com/questions/6958965
  https://stackoverflow.com/questions/46988855