Re: Bulk_insert in postgresql like Microsoft SQL server

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Devendra Yadav <devendra(dot)857(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Bulk_insert in postgresql like Microsoft SQL server
Date: 2018-12-19 17:47:39
Message-ID: CAKFQuwYjJ2svQ7hFbtJXY5+KC=wD3hqyfpeD5qLvyq=U8XaRjg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Dec 19, 2018 at 10:29 AM Devendra Yadav <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.

David J.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Devendra Yadav 2018-12-19 17:58:04 Re: Bulk_insert in postgresql like Microsoft SQL server
Previous Message Devendra Yadav 2018-12-19 17:45:56 Re: Bulk_insert in postgresql like Microsoft SQL server