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@gmx.net wrote:
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.