Re: Bulk_insert in postgresql like Microsoft SQL server

Dear All,

Thank you all for your help. I am able to achieve the same.

Thanks and Regards,
Devendra Yadav

On Thu, Dec 20, 2018, 6:56 PM Thomas Kellerer <spam_eater(at)gmx(dot)net wrote:

> Devendra Yadav schrieb am 19.12.2018 um 18:58:
> >> On Wed, Dec 19, 2018 at 10:29 AM Devendra Yadav <
> devendra(dot)857(at)gmail(dot)com <mailto:devendra(dot)857(at)gmail(dot)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
>
>
>
>
>